@php $acum_total_taxed=0; $acum_total_igv=0; $acum_total=0; $serie_affec = ''; $acum_total_exonerado=0; $acum_total_inafecto=0; $acum_total_free=0; $acum_total_taxed_usd = 0; $acum_total_igv_usd = 0; $acum_total_usd = 0; @endphp @foreach($records as $key => $value) @if(in_array($value->document_type_id,["07","08"]) && $value->note) @php $serie = ($value->note->affected_document) ? $value->note->affected_document->series : $value->note->data_affected_document->series; $number = ($value->note->affected_document) ? $value->note->affected_document->number : $value->note->data_affected_document->number; $serie_affec = $serie.' - '.$number; @endphp @endif @php $signal = $value->document_type_id; $state = $value->state_type_id; @endphp @if($signal == '07') @else @endif @php $value->total_exonerated = (in_array($value->document_type_id,['01','03']) && in_array($value->state_type_id,['09','11'])) ? 0 : $value->total_exonerated; $value->total_unaffected = (in_array($value->document_type_id,['01','03']) && in_array($value->state_type_id,['09','11'])) ? 0 : $value->total_unaffected; $value->total_free = (in_array($value->document_type_id,['01','03']) && in_array($value->state_type_id,['09','11'])) ? 0 : $value->total_free; $value->total_taxed = (in_array($value->document_type_id,['01','03']) && in_array($value->state_type_id,['09','11'])) ? 0 : $value->total_taxed; $value->total_igv = (in_array($value->document_type_id,['01','03']) && in_array($value->state_type_id,['09','11'])) ? 0 : $value->total_igv; $value->total = (in_array($value->document_type_id,['01','03']) && in_array($value->state_type_id,['09','11'])) ? 0 : $value->total; @endphp @php $serie_affec = ''; @endphp @php if($value->currency_type_id == 'PEN'){ /*$acum_total_taxed += $signal != '07' ? $value->total_taxed : -$value->total_taxed ; $acum_total_igv += $signal != '07' ? $value->total_igv : -$value->total_igv ; $acum_total += $signal != '07' ? $value->total : -$value->total ;*/ /*$acum_total_exonerado += $signal != '07' ? $value->total_exonerated : -$value->total_exonerated ; $acum_total_inafecto += $signal != '07' ? $value->total_unaffected : -$value->total_unaffected ; $acum_total_free += $signal != '07' ? $value->total_free : -$value->total_free ;*/ if(($signal == '07' && $state !== '11')){ $acum_total += -$value->total; $acum_total_taxed += -$value->total_taxed; $acum_total_igv += -$value->total_igv; $acum_total_exonerado += -$value->total_exonerated; $acum_total_inafecto += -$value->total_unaffected; $acum_total_free += -$value->total_free; }elseif($signal != '07' && $state == '11'){ $acum_total += 0; $acum_total_taxed += 0; $acum_total_igv += 0; $acum_total_exonerado += 0; $acum_total_inafecto += 0; $acum_total_free += 0; }else{ $acum_total += $value->total; $acum_total_taxed += $value->total_taxed; $acum_total_igv += $value->total_igv; $acum_total_exonerado += $value->total_exonerated; $acum_total_inafecto += $value->total_unaffected; $acum_total_free += $value->total_free; } }else if($value->currency_type_id == 'USD'){ if(($signal == '07' && $state !== '11')){ $acum_total_usd += -$value->total; $acum_total_taxed_usd += -$value->total_taxed; $acum_total_igv_usd += -$value->total_igv; }elseif($signal != '07' && $state == '11'){ $acum_total_usd += 0; $acum_total_taxed_usd += 0; $acum_total_igv_usd += 0; }else{ $acum_total_usd += $value->total; $acum_total_taxed_usd += $value->total_taxed; $acum_total_igv_usd += $value->total_igv; } } @endphp @endforeach

#	Usuario/Vendedor	Tipo Doc	Número	Fecha emisión	Doc. Afectado	Cotización	Caso	Cliente	RUC	Estado	Moneda	Total Exonerado	Total Inafecto	Total Gratuito	Total Gravado	Total IGV	Total
{{$loop->iteration}}	{{$value->user->name}}	{{$value->document_type->id}}	{{$value->series}}-{{$value->number}}	{{$value->date_of_issue->format('Y-m-d')}}	{{$serie_affec }}	{{ ($value->quotation) ? $value->quotation->number_full : '' }}	{{ isset($value->quotation->sale_opportunity) ? $value->quotation->sale_opportunity->number_full : '' }}	{{$value->customer->name}}	{{$value->customer->number}}	{{$value->state_type->description}}	{{$value->currency_type_id}}	{{$signal == '07' ? "-" : "" }}{{$value->total_exonerated}}	{{$signal == '07' ? "-" : "" }}{{$value->total_unaffected}}	{{$signal == '07' ? "-" : "" }}{{$value->total_free}}	{{$signal == '07' ? "-" : "" }}{{$value->total_taxed}}	{{$signal == '07' ? "-" : "" }}{{$value->total_igv}}	{{$signal == '07' ? "-" : "" }}{{$value->total}}	{{ (in_array($value->document_type_id,['01','03']) && in_array($value->state_type_id,['09','11'])) ? 0 : $value->total_exonerated}}	{{ (in_array($value->document_type_id,['01','03']) && in_array($value->state_type_id,['09','11'])) ? 0 : $value->total_unaffected}}	{{ (in_array($value->document_type_id,['01','03']) && in_array($value->state_type_id,['09','11'])) ? 0 : $value->total_free}}	{{ (in_array($value->document_type_id,['01','03']) && in_array($value->state_type_id,['09','11'])) ? 0 : $value->total_taxed}}	{{ (in_array($value->document_type_id,['01','03']) && in_array($value->state_type_id,['09','11'])) ? 0 : $value->total_igv}}	{{ (in_array($value->document_type_id,['01','03']) && in_array($value->state_type_id,['09','11'])) ? 0 : $value->total}}
											Totales PEN	{{number_format($acum_total_exonerado, 2)}}	{{number_format ($acum_total_inafecto, 2 )}}	{{number_format($acum_total_free, 2)}}	{{$acum_total_taxed}}	{{$acum_total_igv}}	{{$acum_total}}
											Totales USD				{{$acum_total_taxed_usd}}	{{$acum_total_igv_usd}}	{{$acum_total_usd}}