@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 TEC 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
| No |
TEC No |
Name |
Section |
Ticket No |
Date of Application |
Date Validity |
Processed By |
Approved By |
@foreach($val as $key1 => $val1)
| {{ $start_count ++ }} |
{{ 'TEC-'.str_pad($val1->tec_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) |
{{--
@else
{{ $val1->generate_to_email ? 'Yes' : 'No' }} |
@endif
--}}
@endforeach
{{ 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}}
@elseif(isset($status) && $status == '3')
@if($key == 0)
List of TEC Applications (Denied)
@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
| No |
Application No |
Name |
Date of Application |
Reason of Denial |
Completed/Processed |
Processed By |
Approved By |
@foreach($val as $key1 => $val1)
@php
$reason_denied = $val1->denied_desc;
if($val1->denial_id == 0) $reason_denied = $val1->denial_msg;
@endphp
| {{ $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) |
@endforeach
{{ 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}}
@if($key == 0)
List of TEC 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
| No |
Date of Application |
Name |
Airline |
Status |
@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
| {{ $start_count ++ }} |
{{ date('M d Y', strtotime($val1->date_application)) }} |
{{ strtoupper($val1->full_name) }} |
{{ $val1->airline_name }} |
{{ $status }} |
@endforeach
{{ 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
@elseif($report_name == 'summary_section_tec')
@if($key == 0)
Summary Report of TEC 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
| Code |
Description |
Total |
@php
$array_key_last = last($applications_chunk);
$last_val = last($array_key_last);
@endphp
@foreach($val as $key1 => $val1)
| {{ strtoupper($val1->code) }} |
{{ $val1->name }} |
{{ $val1->count }} |
@if($val1->id == $last_val->id)
| Total |
|
{{ $total_count }} |
@endif
@endforeach
{{ 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}}
@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
| EXEMPTION |
@foreach($val as $key1 => $val1)
| {{ strtoupper($val1->code) }} |
@endforeach
@php
$array_key_last = last($applications_chunk);
$last_val = last($array_key_last);
@endphp
@foreach($val as $key1 => $val1)
| {{ strtoupper($val1->cnt) }} |
@endforeach
{{ 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 }}
Prepared by:
{{$prepared->first_name}} {{ $prepared->last_name}}
{{ $prepared->position}}
Noted by:
{{$noted->first_name}} {{ $noted->last_name}}
{{ $noted->position}}
@elseif ($report_name == 'process_time_motion')
@if($key == 0)
Exemption 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
| MONTHLY TIME AND MOTION(EXEMPTION SECTION) |
| PROCESSOR |
| DATE |
QTY |
TOTAL TIME |
AVERAGE TIME |
@php
$array_key_last = last($applications_chunk);
$last_val = last($array_key_last);
@endphp
@foreach($val as $key1 => $val1)
| {{ strtoupper($val1->date_application) }} |
{{ strtoupper($val1->qty) }} |
{{ strtoupper($val1->timeSum) }} |
{{ strtoupper($val1->timeAvg) }} |
@endforeach
@if($val1->id == $last_val->id)
| Total |
{{ $qryTotal->qty }} |
{{ $qryTotal->timeSum }} |
{{ $qryTotal->timeAvg }} |
@endif
{{ 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 Travel Tax Excemption Certificate Summary
@if(isset($month))
| TEC Issuance for the Month of {{ date('F Y', strtotime($month.'/01/'.$year)) }} |
@else
TEC Issuance for the Period of {{ date('F d, Y',strtotime($start_date)) }} - {{ date('F d, Y',strtotime($end_date)) }} |
@endif
| TEC Beginning |
TEC Ending |
Total Issuance |
@php
$array_key_last = last($applications_chunk);
$array_key_first = $applications_chunk[0];
$first = $array_key_first->tec_no;
$last = $array_key_last->tec_no;
$last_tec_no = 'TEC - '.str_pad($last, 6 ,"0", STR_PAD_LEFT);
$first_tec_no = 'TEC - '.str_pad($first, 6 ,"0", STR_PAD_LEFT);
@endphp
|
{{ $first_tec_no }}
|
{{ $last_tec_no }}
|
{{ count($applications_chunk) }}
|
{{ 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 ?? ''}}
 }}){kind=logo}
 }})