@php
header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header ("Last-Modified: " . gmdate("D,d M YH:i:s") . " GMT");
header ("Cache-Control: no-cache, must-revalidate");
header ("Pragma: no-cache");
header ("Content-type: application/x-msexcel");
header ("Content-Disposition: attachment; filename=\"inscritos.xls\"" );
header ("Content-Description: PHP Generated Data" );
@endphp
| # |
Número |
Nome |
Email |
Telefone |
Documento |
Sexo |
Nascimento |
Modalidade |
Ingresso |
Categoria |
Status |
Valor |
@if ($idmod == 0)
@foreach($evento->modalides as $m)
@php
$cats = App\PaidEventPaidEventModalidadePaidEventCategory::where('paid_event_paid_event_modalidade_id', $m->id)->get();
@endphp
@if ($cats->count() > 0)
@foreach ($cats as $c )
@if ($c->categoria->formulario->extras->count() > 0)
@foreach ($c->categoria->formulario->extras as $ex )
{{$ex->rotulo}} |
@endforeach
@endif
@endforeach
@endif
@endforeach
@else
@if ($idcat == 0)
@php
$m = $evento->modalides()->where('paid_event_paid_event_modalidade.paid_event_modalidade_id', $idmod)->first();
$cats = App\PaidEventPaidEventModalidadePaidEventCategory::where('paid_event_paid_event_modalidade_id', $m->id)->get();
@endphp
@if ($cats->count() > 0)
@foreach ($cats as $c )
@if ($c->categoria->formulario->extras->count() > 0)
@foreach ($c->categoria->formulario->extras as $ex )
{{$ex->rotulo}} |
@endforeach
@endif
@endforeach
@endif
@else
@php
$m = $evento->modalides()->where('paid_event_paid_event_modalidade.paid_event_modalidade_id', $idmod)->first();
$cat = App\PaidEventPaidEventModalidadePaidEventCategory::
where('paid_event_paid_event_modalidade_id', $m->id)
->where('paid_event_category_id', $idcat)
->first();
@endphp
@if ($cat->categoria->formulario->extras->count() > 0)
@foreach ($cat->categoria->formulario->extras as $ex )
{{$ex->rotulo}} |
@endforeach
@endif
@endif
@endif
@if (count($inscritos) > 0)
@foreach ($inscritos as $ins )
| {{$ins['id']}} |
{{$ins['numero']}} |
{{$ins['nome']}} |
{{$ins['email']}} |
{{$ins['fone']}} |
{{$ins['documento']}} |
{{$ins['sexo']}} |
{{$ins['nasc']}} |
{{$ins['modalidade']}} |
{{$ins['lote']}} |
{{$ins['categoria']}} |
{{$ins['status']}} |
{{$ins['valor']}} |
@if ($idmod == 0)
@foreach($evento->modalides as $m)
@php
$cats = App\PaidEventPaidEventModalidadePaidEventCategory::where('paid_event_paid_event_modalidade_id', $m->id)->get();
@endphp
@if ($cats->count() > 0)
@foreach ($cats as $c )
@if ($c->categoria->formulario->extras->count() > 0)
@foreach ($c->categoria->formulario->extras as $ex )
@php
$resposta = App\PaidEventInscritoExtra::where('paid_event_inscrito_id',$ins['key'] )->where('form_extra_id', $ex->id )->first();
@endphp
@if ($resposta)
{{$resposta->valor}} |
@else
|
@endif
@endforeach
@endif
@endforeach
@endif
@endforeach
@else
@if ($idcat == 0)
@php
$m = $evento->modalides()->where('paid_event_paid_event_modalidade.paid_event_modalidade_id', $idmod)->first();
$cats = App\PaidEventPaidEventModalidadePaidEventCategory::where('paid_event_paid_event_modalidade_id', $m->id)->get();
@endphp
@if ($cats->count() > 0)
@foreach ($cats as $c )
@if ($c->categoria->formulario->extras->count() > 0)
@foreach ($c->categoria->formulario->extras as $ex )
@php
$resposta = App\PaidEventInscritoExtra::where('paid_event_inscrito_id',$ins['key'] )->where('form_extra_id', $ex->id )->first();
@endphp
@if ($resposta)
{{$resposta->valor}} |
@else
|
@endif
@endforeach
@endif
@endforeach
@endif
@else
@php
$m = $evento->modalides()->where('paid_event_paid_event_modalidade.paid_event_modalidade_id', $idmod)->first();
$cat = App\PaidEventPaidEventModalidadePaidEventCategory::
where('paid_event_paid_event_modalidade_id', $m->id)
->where('paid_event_category_id', $idcat)
->first();
@endphp
@if ($cat->categoria->formulario->extras->count() > 0)
@foreach ($cat->categoria->formulario->extras as $ex )
@php
$resposta = App\PaidEventInscritoExtra::where('paid_event_inscrito_id',$ins['key'] )->where('form_extra_id', $ex->id )->first();
@endphp
@if ($resposta)
{{$resposta->valor}} |
@else
|
@endif
@endforeach
@endif
@endif
@endif
@endforeach
@endif