@include('layouts.auth-partials.meta') @yield('meta') @include('layouts.auth-partials.css') @yield('css')
@php $start_count = 1; @endphp @foreach($applications_chunk as $key => $val) @if($report_name == 'airlines_passenger') @if(isset($status) && $status == '2')
@if($key == 0)
List of TTR Applications (Approved)
@if(isset($month) && isset($year))
For the month of {{ date('F Y', strtotime($month.'/01/'.$year)) }}

@else
For the period of {{ date('F d, Y',strtotime($start_date)) }} - {{ date('F d, Y',strtotime($end_date)) }}

@endif
@endif
@foreach($val as $key1 => $val1) {{-- @else @endif --}} @endforeach
No TTR No Name Section Ticket No Date of Application Date Validity Processed By Approved By
{{ $start_count ++ }} {{ 'TTR-'.str_pad($val1->rtt_no, 5, '0', STR_PAD_LEFT)}} {{ strtoupper($val1->full_name) }} {{ $val1->sec_code }} {{ $val1->ticket_no }} {{ date('M d Y', strtotime($val1->date_application)) }} {{ date('M d Y', strtotime($val1->date_validity)) }} {{ $val1->processor_full_name }}(Processor) {{ $val1->supervisor_full_name }}(Signatory){{ $val1->generate_to_email ? 'Yes' : 'No' }}

{{ date('M d, Y H:i:s').' - '.Auth::user()->username }}
@elseif(isset($status) && $status == '3')
@if($key == 0)
List of TTR Applications (Denied)
@if(isset($month) && isset($year))
For the month of {{ date('F Y', strtotime($month.'/01/'.$year)) }}

@endif
@endif
@foreach($val as $key1 => $val1) @php $reason_denied = $val1->denied_desc; if($val1->denial_id == 0) $reason_denied = $val1->denial_msg; @endphp @endforeach
No Application No Name Date of Application Reason of Denial Completed/Processed Processed By Approved By
{{ $start_count ++ }} {{ 'APP-'.str_pad($val1->id, 5, '0', STR_PAD_LEFT)}} {{ strtoupper($val1->full_name) }} {{ date('M d Y', strtotime($val1->date_application)) }} {{ $reason_denied }} {{ $val1->generate_to_email ? 'Yes' : 'No' }} {{ $val1->processor_full_name }}(Processor) {{ $val1->supervisor_full_name }}(Signatory)

{{ date('M d, Y H:i:s').' - '.Auth::user()->username }}
@else
@if($key == 0)
List of TTR Applications
@if(isset($month) && isset($year))
For the month of {{ date('F Y', strtotime($month.'/01/'.$year)) }}

@else
For the period of {{ date('F d, Y',strtotime($start_date)) }} - {{ date('F d, Y',strtotime($end_date)) }}

@endif
@endif
@foreach($val as $key1 => $val1) @php $status = 'undefined'; if(in_array($val1->status, array_column($application_status, 'id'))) { $status_key = array_search($val1->status, array_column($application_status, 'id')); $status = ucfirst($application_status[$status_key]['name']); } @endphp @endforeach
No Date of Application Name Airline Status
{{ $start_count ++ }} {{ date('M d Y', strtotime($val1->date_application)) }} {{ strtoupper($val1->full_name) }} {{ $val1->airline_name }} {{ $status }}

{{ date('M d, Y H:i:s').' - '.Auth::user()->username }}
@endif @elseif($report_name == 'summary_section_tr')
@if($key == 0)
Summary Report of TTR Applications
@if(isset($month) && isset($year))
For the month of {{ date('F Y', strtotime($month.'/01/'.$year)) }}

@else
For the period of {{ date('F d, Y',strtotime($start_date)) }} - {{ date('F d, Y',strtotime($end_date)) }}

@endif
@endif
@php $array_key_last = last($applications_chunk); $last_val = last($array_key_last); @endphp @foreach($val as $key1 => $val1) @if($val1->id == $last_val->id) @endif @endforeach
Code Description Total
{{ strtoupper($val1->code) }} {{ $val1->name }} {{ $val1->count }}
Total   {{ $total_count }}

{{ date('M d, Y H:i:s').' - '.Auth::user()->username }}
@elseif ($report_name == 'summary_process_time')
@if($key == 0)
Summary of Time & Motion Report
@if(isset($month) && isset($year))
For the month of {{ date('F Y', strtotime($month.'/01/'.$year)) }}

@else
For the period of {{ date('F d, Y',strtotime($start_date)) }} - {{ date('F d, Y',strtotime($end_date)) }}

@endif
@endif
@foreach($val as $key1 => $val1) @endforeach @php $array_key_last = last($applications_chunk); $last_val = last($array_key_last); @endphp @foreach($val as $key1 => $val1) @endforeach
EXEMPTION
{{ strtoupper($val1->code) }}
{{ strtoupper($val1->cnt) }}

{{ date('M d, Y H:i:s').' - '.Auth::user()->username }}

Total Processed: {{ $processedTime->total_processed}}
Total Processing Time: {{ $processedTime->timeSum }}
Average System Processing Time Per Client: {{ $processedTime->timeAvg }}
@elseif ($report_name == 'process_time_motion')
@if($key == 0)
REFUND Time & Motion Report
@if(isset($month) && isset($year))
For the month of {{ date('F Y', strtotime($month.'/01/'.$year)) }}

@else
For the period of {{ date('F d, Y',strtotime($start_date)) }} - {{ date('F d, Y',strtotime($end_date)) }}

@endif
@endif
@php $array_key_last = last($applications_chunk); $last_val = last($array_key_last); @endphp @foreach($val as $key1 => $val1) @endforeach @if($val1->id == $last_val->id) @endif
MONTHLY TIME AND MOTION(REFUND SECTION)
PROCESSOR
DATE QTY TOTAL TIME AVERAGE TIME
{{ strtoupper($val1->date_application) }} {{ strtoupper($val1->qty) }} {{ strtoupper($val1->timeSum) }} {{ strtoupper($val1->timeAvg) }}
Total {{ $qryTotal->qty }} {{ $qryTotal->timeSum }} {{ $qryTotal->timeAvg }}

{{ date('M d, Y H:i:s').' - '.Auth::user()->username }}



Prepared by:


{{$prepared->first_name}} {{ $prepared->last_name}}
{{ $prepared->position}}
Noted by:


{{$noted->first_name}} {{ $noted->last_name}}
{{ $noted->position}}
@endif @endforeach @if($applications_chunk) @if($report_name == 'summary_certificate')
Issued Refund Travel Tax Certificate Summary
@if(isset($month)) @else @endif @php $array_key_last = last($applications_chunk); $array_key_first = $applications_chunk[0]; $first = $array_key_first->rtt_no; $last = $array_key_last->rtt_no; $last_rtt_no = 'TTR - '.str_pad($last, 6 ,"0", STR_PAD_LEFT); $first_rtt_no = 'TTR - '.str_pad($first, 6 ,"0", STR_PAD_LEFT); @endphp
TTR Issuance for the Month of {{ date('F Y', strtotime($month.'/01/'.$year)) }}TTR Issuance for the Period of {{ date('F d, Y',strtotime($start_date)) }} - {{ date('F d, Y',strtotime($end_date)) }}
TTR Beginning TTR Ending Total Issuance
{{ $first_rtt_no }} {{ $last_rtt_no }} {{ count($applications_chunk) }}

{{ date('M d, Y H:i:s').' - '.Auth::user()->username }}
@endif @endif
@include('layouts.auth-partials.scripts') @yield('scripts')