{{--

FORMATO 13.1: "REGISTRO DE INVENTARIO PERMANENTE VALORIZADO - DETALLE DEL INVENTARIO VALORIZADO"

--}}

FORMATO 13.1: "REGISTRO DE INVENTARIO PERMANENTE VALORIZADO"
PERÍODO: @if ($additionalData['month']) {{ get_month($additionalData['month']) }} @endif {{ $additionalData['period'] }}
RUC: {{ $company->number }}
{{ strtoupper($company->name) }}
ESTABLECIMIENTO (1):	{{ optional($establishment)->description }}

@if ($show_init) @else @endif @php $totals = [ 'input_quantity' => 0, 'input_unit_price' => 0, 'input_total' => 0, 'output_quantity' => 0, 'output_unit_price' => 0, 'output_total' => 0, 'balance_quantity' => $init_stock, 'balance_total' => $init_cost_total, 'balance_cost' => $init_cost_unit, ]; // get the last row with key 'type' = 'output' $last_output = array_reverse( array_filter($records, function ($row) { return $row['type'] == 'output'; }), )[0] ?? []; // get the last row with key 'type' = 'input' $last_input = array_reverse( array_filter($records, function ($row) { return $row['type'] == 'input'; }), )[0] ?? []; //get the last row of records $last_row = array_reverse($records)[0] ?? []; @endphp @foreach ($records as $row) {{-- --}} {{-- --}} {{-- ENTRADAS --}} {{-- SALIDAS --}} @if ($row['type'] == 'output') @else @endif {{-- SALDO --}} @php // $balance_quantity += $row['quantity'] * $row['factor']; // $balance_total += $row['total'] * $row['factor']; // $balance_cost = ($balance_quantity != 0) ? round($balance_total / $balance_quantity, 4) : null; if ($row['type'] == 'input') { $totals['input_quantity'] += $row['input_quantity']; $totals['input_unit_price'] += $row['input_unit_price']; $totals['input_total'] += $row['input_total']; } else { $totals['output_quantity'] += $row['output_quantity']; $totals['output_unit_price'] += $row['output_unit_price']; $totals['output_total'] += $row['output_total']; } $totals['balance_quantity'] += $row['balance_quantity']; $totals['balance_total'] += $row['balance_total_cost']; $totals['balance_cost'] += $row['balance_unit_cost']; @endphp @endforeach

FECHA	DOCUMENTO	OPERACION	ENTRADAS			SALIDAS			SALDO
		Código: {{ $additionalData['internal_id'] }}
	Unidad de medida: {{ $additionalData['unit_type_table_six']['code'] }} {{-- {{ $additionalData['unit_type_table_six']['description'] }} --}}	Saldo anterior							{{-- {{ $balance_quantity }} --}} {{ number_format($init_stock,0) }}	{{-- {{ $balance_cost }} --}} {{ number_format($init_cost_unit,4) }}	{{-- {{ $balance_total }} --}} {{ number_format($init_cost_total,2) }}
Descripción: {{ strtoupper($additionalData['description']) }}
Método de evaluación: COSTO PROMEDIO
{{ \Carbon\Carbon::parse($row['date_of_issue'])->format('d/m/Y') }}	{{ $row['document_type_id'] }}	{{ $row['series'] }} - {{ $row['number'] }}		{{ $row['operation_type_code'] }} {{ get_operation($row['operation_type_code']) }}	{{ number_format($row['input_quantity'],0)}}	{{ number_format($row['input_unit_price'],4) }}	{{ number_format($row['input_total'],2) }}	{{ number_format($row['output_quantity'],0) }}	{{ number_format($row['output_unit_price'],4) }}	{{ number_format($row['output_total'],2) }}				{{-- {{ $balance_quantity }} --}} {{ number_format($row['balance_quantity'],0) }}	{{-- {{ $balance_cost }} --}} {{ number_format($row['balance_unit_cost'],4) }}	{{-- {{ $balance_total }} --}} {{ number_format($row['balance_total_cost'],2) }}
			{{ number_format(checkKey($last_input, 'input_quantity', 0),0) }}	{{ number_format(checkKey($last_input, 'input_unit_price', 0),4) }}	{{ number_format(checkKey($last_input, 'input_total', 0),2) }}	{{ number_format(checkKey($last_output, 'output_quantity', 0),0) }}	{{ number_format(checkKey($last_output, 'output_unit_price', 0),4) }}	{{ number_format(checkKey($last_output, 'output_total', 0),2) }}	{{ number_format(checkKey($last_row, 'balance_quantity', 0),0) }}	{{ number_format(checkKey($last_row, 'balance_unit_cost', 0),4) }}	{{ number_format(checkKey($last_row, 'balance_total_cost', 0),2) }}