<<<<<<< HEAD Advances Report

Advances Report

Generated on {{ \Carbon\Carbon::now()->format('d M, Y') }}

@php $grandDebit = 0; $grandCredit = 0; $grandBalance = 0; @endphp @foreach ($advances as $key => $advance) @php $debitSum = $advance->lines->sum('debit'); $creditSum = $advance->lines->sum('credit'); $balance = $debitSum - $creditSum; $grandDebit += $debitSum; $grandCredit += $creditSum; $grandBalance += $balance; $entity = $advance->accountEntity?->entity; if ($entity instanceof \App\Models\Farmer) { $entityNumber = $entity->farmer_number ?? $advance->code; $entityName = trim(($entity->farmer_fname ?? '') . ' ' . ($entity->farmer_lname ?? '')); } elseif ($entity instanceof \App\Models\Buyer) { $entityNumber = $entity->buyer_number ?? $advance->code; $entityName = $entity->buyer_name ?? $advance->name; } elseif ($entity instanceof \App\Models\Employee) { $entityNumber = $entity->employee_number ?? $advance->code; $entityName = trim(($entity->first_name ?? '') . ' ' . ($entity->last_name ?? '')); } else { $entityNumber = $advance->code; $entityName = $advance->name; } @endphp @endforeach
# Name Number Total Debit Total Credit Balance
{{ $key + 1 }} {{ $entityName }} {{ $entityNumber }} {{ number_format($debitSum, 0) }} {{ number_format($creditSum, 0) }} {{ number_format($balance, 0) }}
Totals: {{ number_format($grandDebit, 0) }} {{ number_format($grandCredit, 0) }} {{ number_format($grandBalance, 0) }}
======= @extends('layouts.pdf.base') @php($pdfBrand = ['primaryColor' => '#6F4E37', 'accentColor' => '#6F4E37']) @section('pdf-title', 'Hope Coffee Advances Report') @section('pdf-subtitle', 'Hope Coffee Program') @section('pdf-meta') Generated on {{ \Carbon\Carbon::now()->format('d M Y, h:i A') }} @endsection @section('pdf-content') @php $grandDebit = 0; $grandCredit = 0; $grandBalance = 0; @endphp @foreach ($advances as $key => $advance) @php $debitSum = $advance->lines->sum('debit'); $creditSum = $advance->lines->sum('credit'); $balance = $debitSum - $creditSum; $grandDebit += $debitSum; $grandCredit += $creditSum; $grandBalance += $balance; $entity = $advance->accountEntity?->entity; if ($entity instanceof \App\Models\Farmer) { $entityNumber = $entity->farmer_number ?? $advance->code; $entityName = trim(($entity->farmer_fname ?? '').' '.($entity->farmer_lname ?? '')); } elseif ($entity instanceof \App\Models\Buyer) { $entityNumber = $entity->buyer_number ?? $advance->code; $entityName = $entity->buyer_name ?? $advance->name; } elseif ($entity instanceof \App\Models\Employee) { $entityNumber = $entity->employee_number ?? $advance->code; $entityName = trim(($entity->first_name ?? '').' '.($entity->last_name ?? '')); } else { $entityNumber = $advance->code; $entityName = $advance->name; } @endphp @endforeach
# Name Number Total Debit Total Credit Balance
{{ $key + 1 }} {{ $entityName }} {{ $entityNumber }} {{ number_format($debitSum, 0) }} {{ number_format($creditSum, 0) }} {{ number_format($balance, 0) }}
Totals {{ number_format($grandDebit, 0) }} {{ number_format($grandCredit, 0) }} {{ number_format($grandBalance, 0) }}
@endsection >>>>>>> origin/main