Reporte de Ingresos y Egresos

@php $all_documents = collect($data['all_documents'])->sortBy('order_number_key'); $income_records = $all_documents->where('type_transaction_prefix', 'income'); $egress_records = $all_documents->where('type_transaction_prefix', 'egress'); $income_methods_payment = $income_records->pluck('payment_method_description')->unique(); // Iterar sobre los métodos de pago y crear un array con los documentos que tienen ese método de pago $income_methods_payment = $income_methods_payment->map(function ($item, $key) use ($income_records) { $documents = $income_records->where('payment_method_description', $item)->values(); if ($item == null) { $item = 'Otros'; } return [ 'payment_method' => $item, 'documents' => $documents, ]; }); @endphp Reporte de Ingresos y Egresos @if (count($income_records) > 0)

Ingresos

@isset($detail) @endisset @foreach ($income_methods_payment as $key => $value) @php $total_acum = 0; @endphp @foreach ($value['documents'] as $document) @isset($detail) @endisset @php $total_acum += $document['total_payments']; @endphp @endforeach @endforeach

#	Tipo	TD	DOC	N° Op.	Fecha emisión	Cliente/Proveedor	N° Documento	MON	Pagado
{{ $value['payment_method'] }}
{{ $loop->iteration }}	@if(strpos($document['type_transaction'], 'cuenta') !== false) Venta (cuenta) @else {{ $document['type_transaction'] }} @endif	@if ($document['document_type_description'] == '01') {{-- FACTURA ELECTRÓNICA --}} 01 @elseif ($document['document_type_description'] == '03') {{-- BOLETA DE VENTA ELECTRÓNICA --}} 03 @else @if ($document['document_type_description'] == 'FACTURA ELECTRÓNICA') 01 @elseif ($document['document_type_description'] == 'BOLETA DE VENTA ELECTRÓNICA') 03 @elseif ($document['document_type_description'] == 'NOTA DE VENTA') 80 @elseif (strpos($document['document_type_description'], 'COTIZACION') !== false) COT @else {{ $document['document_type_description'] }} @endif @endif	{{ $document['number'] }}	{{ $document['reference'] }}	{{ \Carbon\Carbon::parse($document['date_of_issue'])->format('d-m-Y') }}	{{ $document['customer_name'] }}	{{ $document['customer_number'] }}	{{ $document['currency_type_id'] }}	{{ $document['total_payments'] ?? '0.00' }}
								Total	{{ number_format($total_acum, 2, '.', '') }}

@endif @if (count($egress_records) > 0)

Egresos

@foreach ($egress_records as $key => $value) @endforeach

#	Tipo	TD	DOC	Fecha emisión	Cliente/Proveedor	N° Documento	MON	Pagado	Total
{{ $loop->iteration }}	{{ $value['type_transaction'] }}	@if ($value['document_type_description'] == '01') {{-- FACTURA ELECTRÓNICA --}} 01 @elseif ($value['document_type_description'] == '03') {{-- BOLETA DE VENTA ELECTRÓNICA --}} 03 @else @if ($value['document_type_description'] == 'FACTURA ELECTRÓNICA') 01 @elseif ($value['document_type_description'] == 'BOLETA DE VENTA ELECTRÓNICA') 03 @elseif ($value['document_type_description'] == 'NOTA DE VENTA') 80 @elseif (strpos($value['document_type_description'], 'COTIZACION') !== false) COT @else {{ $value['document_type_description'] }} @endif @endif	{{ $value['number'] }}	{{ \Carbon\Carbon::parse($value['date_of_issue'])->format('d-m-Y') }}	{{ $value['customer_name'] }}	{{ $value['customer_number'] }}	{{ $value['currency_type_id'] }}	{{ $value['total_payments'] ?? '0.00' }}	{{ str_replace('-', '', $value['total_string']) }}

@endif