@php $establishment = $cash->user->establishment; $final_balance = 0; $cash_income = 0; $cash_egress = 0; $cash_final_balance = 0; $cash_documents = $cash->cash_documents; foreach ($cash_documents as $cash_document) { if($cash_document->sale_note){ if($cash_document->sale_note->currency_type_id == 'PEN'){ if(in_array($cash_document->sale_note->state_type_id, ['01','03','05','07','13'])){ $cash_income += $cash_document->sale_note->total; $final_balance += $cash_document->sale_note->total; } }else{ if(in_array($cash_document->sale_note->state_type_id, ['01','03','05','07','13'])){ $cash_income += $cash_document->sale_note->total * $cash_document->sale_note->exchange_rate_sale; $final_balance += $cash_document->sale_note->total * $cash_document->sale_note->exchange_rate_sale; } } if(in_array($cash_document->sale_note->state_type_id, ['01','03','05','07','13'])){ if( count($cash_document->sale_note->payments) > 0) { $pays = $cash_document->sale_note->payments; foreach ($methods_payment as $record) { $record->sum = ($record->sum + $pays->where('payment_method_type_id', $record->id)->sum('payment') ); } } } } else if($cash_document->document){ if($cash_document->document->currency_type_id == 'PEN'){ if(in_array($cash_document->document->state_type_id, ['01','03','05','07','13'])){ $cash_income += $cash_document->document->total; $final_balance += $cash_document->document->total; } }else{ if(in_array($cash_document->document->state_type_id, ['01','03','05','07','13'])){ $cash_income += $cash_document->document->total * $cash_document->document->exchange_rate_sale; $final_balance += $cash_document->document->total * $cash_document->document->exchange_rate_sale; } } $payment_condition_id = $cash_document->document->payment_condition_id; if (in_array($cash_document->document->state_type_id, ['01','03','05','07','13']) && $payment_condition_id === '01') { if( count($cash_document->document->payments) > 0) { $pays = $cash_document->document->payments; foreach ($methods_payment as $record) { $record->sum = ($record->sum + $pays->where('payment_method_type_id', $record->id)->whereIn('document.state_type_id', ['01','03','05','07','13'])->sum('payment')); } } } else { foreach ($methods_payment as $record) { if ($record->id === '09') { $record->sum += $cash_document->document->total; } } } } else if($cash_document->expense_payment){ if($cash_document->expense_payment->expense->state_type_id == '05'){ if($cash_document->expense_payment->expense->currency_type_id == 'PEN'){ $cash_egress += $cash_document->expense_payment->payment; $final_balance -= $cash_document->expense_payment->payment; }else{ $cash_egress += $cash_document->expense_payment->payment * $cash_document->expense_payment->expense->exchange_rate_sale; $final_balance -= $cash_document->expense_payment->payment * $cash_document->expense_payment->expense->exchange_rate_sale; } } } } $cash_final_balance = $final_balance + $cash->beginning_balance; //$cash_income = ($final_balance > 0) ? ($cash_final_balance - $cash->beginning_balance) : 0; @endphp Reporte POS - {{$cash->user->name}} - {{$cash->date_opening}} {{$cash->time_opening}}

Reporte Punto de Venta

@if(!$cash->state) @endif

Empresa: {{$company->name}}

Fecha reporte: {{date('Y-m-d')}}

Ruc: {{$company->number}}

Establecimiento: {{$establishment->address}} - {{$establishment->department->description}} - {{$establishment->district->description}}

Vendedor: {{$cash->user->name}}

Fecha y hora apertura: {{$cash->date_opening}} {{$cash->time_opening}}

Estado de caja: {{($cash->state) ? 'Aperturada':'Cerrada'}}

Fecha y hora cierre: {{$cash->date_closed}} {{$cash->time_closed}}

Montos de operación:

Saldo inicial: S/. {{number_format($cash->beginning_balance, 2, ".", "")}}

Ingreso: S/. {{number_format($cash_income, 2, ".", "")}}

Saldo final: S/. {{number_format($cash_final_balance, 2, ".", "")}}

Egreso: S/. {{number_format($cash_egress, 2, ".", "")}}

@if($cash_documents->count())
@foreach($methods_payment as $item) @endforeach
# Descripcion Suma
{{ $loop->iteration }} {{ $item->name }} {{ number_format($item->sum, 2, ".", "") }}

@php $all_documents = []; foreach ($cash_documents as $key => $value) { if($value->sale_note){ $all_documents[] = $value; }else if($value->document){ $all_documents[] = $value; }else if($value->expense_payment){ if($value->expense_payment->expense->state_type_id == '05'){ $all_documents[] = $value; } } } @endphp @foreach($all_documents as $key => $value) @php $type_transaction = null; $document_type_description = null; $number = null; $date_of_issue = null; $customer_name = null; $customer_number = null; $currency_type_id = null; $total = null; if($value->sale_note){ $type_transaction = 'Venta'; $document_type_description = 'NOTA DE VENTA'; $number = $value->sale_note->number_full; $date_of_issue = $value->sale_note->date_of_issue->format('Y-m-d'); $customer_name = $value->sale_note->customer->name; $customer_number = $value->sale_note->customer->number; $total = $value->sale_note->total; if(!in_array($value->sale_note->state_type_id, ['01','03','05','07','13'])){ $total = 0; } $currency_type_id = $value->sale_note->currency_type_id; } else if($value->document){ $type_transaction = 'Venta'; $document_type_description = $value->document->document_type->description; $number = $value->document->number_full; $date_of_issue = $value->document->date_of_issue->format('Y-m-d'); $customer_name = $value->document->customer->name; $customer_number = $value->document->customer->number; $total = $value->document->total; if(!in_array($value->document->state_type_id, ['01','03','05','07','13'])){ $total = 0; } $currency_type_id = $value->document->currency_type_id; } else if($value->expense_payment){ $type_transaction = 'Gasto'; $document_type_description = $value->expense_payment->expense->expense_type->description; $number = $value->expense_payment->expense->number; $date_of_issue = $value->expense_payment->expense->date_of_issue->format('Y-m-d'); $customer_name = $value->expense_payment->expense->supplier->name; $customer_number = $value->expense_payment->expense->supplier->number; $total = -$value->expense_payment->payment; $currency_type_id = $value->expense_payment->expense->currency_type_id; } @endphp @endforeach
# Tipo transacción Tipo documento Documento Fecha emisión Cliente/Proveedor N° Documento Moneda Total
{{ $loop->iteration }} {{ $type_transaction }} {{ $document_type_description }} {{ $number }} {{ $date_of_issue}} {{ $customer_name }} {{$customer_number }} {{ $currency_type_id }} {{ number_format($total,2, ".", "") }}
@else

No se encontraron registros.

@endif