@extends('backend.layouts.main')

@section('title', 'MLI ATS | Reports: Expired Reports')

@section('content')
    <div class="container px-6 mx-auto grid">
        @include('backend.share.title', ['title' => 'Reports: Expired Reports'])
        <div class="md:flex flex-none">
            <div class="px-3 py-3  mb-2 mr-3 bg-white rounded-lg shadow-md w-full">
                <div class="p-3">
                    <div class="border-b border-gray-200 flex">
                        @include('backend.report.expired-activity.items.header')
                    </div>
                    <div class="overflow-x-auto">
                        <table class="w-full table-auto">
                            <thead>
                                <tr class="bg-primary-100 text-gray-500 text-xs tracking-wider">
                                    <th class="py-3 px-6">#</th>
                                    <th class="py-3 px-6">
                                        <a class="flex"
                                            href="{{ route('admin.reports.expired-activity', ['order_by' => 'activity_id', 'sort_order' => $next_order]) }}">
                                            <span>AID</span>
                                            <span class="ml-1">
                                                @include('backend.report.expired-activity.sort-icon', [
                                                    'sort_order' => $next_order,
                                                ])
                                            </span>
                                        </a>
                                    </th>
                                    <th class="py-3 px-6">
                                        <a class="flex"
                                            href="{{ route('admin.reports.expired-activity', ['order_by' => 'project_code', 'sort_order' => $next_order]) }}">
                                            <span>MLIP</span>
                                            <span class="ml-1">
                                                @include('backend.report.expired-activity.sort-icon', [
                                                    'sort_order' => $next_order,
                                                ])
                                            </span>
                                        </a>
                                    </th>
                                    <th class="py-3 px-6">
                                        <a class="flex"
                                            href="{{ route('admin.reports.expired-activity', ['order_by' => 'jp_cr_code', 'sort_order' => $next_order]) }}">
                                            <span>JP/EP CR Code</span>
                                            <span class="ml-1">
                                                @include('backend.report.expired-activity.sort-icon', [
                                                    'sort_order' => $next_order,
                                                ])
                                            </span>
                                        </a>
                                    </th>
                                    <th class="py-3 px-6">JP/EP Code</th>
                                    <th class="py-3 px-6">
                                        <a class="flex"
                                            href="{{ route('admin.reports.expired-activity', ['order_by' => 'activity_title', 'sort_order' => $next_order]) }}">
                                            <span>Activity Title</span>
                                            <span class="ml-1">
                                                @include('backend.report.expired-activity.sort-icon', [
                                                    'sort_order' => $next_order,
                                                ])
                                            </span>
                                        </a>
                                    </th>
                                    <th class="py-3 px-6">Type</th>
                                    <th class="py-3 px-6">Accred.</th>
                                    <th class="py-3 px-6">
                                        <a class="flex"
                                            href="{{ route('admin.reports.expired-activity', ['order_by' => 'start_date', 'sort_order' => $next_order]) }}">
                                            <span>RELEASE</span>
                                            <span class="ml-1">
                                                @include('backend.report.expired-activity.sort-icon', [
                                                    'sort_order' => $next_order,
                                                ])
                                            </span>
                                        </a>
                                    </th>
                                    <th class="py-3 px-6">
                                        <a class="flex"
                                            href="{{ route('admin.reports.expired-activity', ['order_by' => 'expiration_date', 'sort_order' => $next_order]) }}">
                                            <span>EXPIRE</span>
                                            <span class="ml-1">
                                                @include('backend.report.expired-activity.sort-icon', [
                                                    'sort_order' => $next_order,
                                                ])
                                            </span>
                                        </a>
                                    </th>
                                    <th class="py-3 px-6">
                                        <a class="flex"
                                            href="{{ route('admin.reports.expired-activity', ['order_by' => 'expiration_date', 'sort_order' => $next_order]) }}">
                                            <span>Days To Expiration</span>
                                            <span class="ml-1">
                                                @include('backend.report.expired-activity.sort-icon', [
                                                    'sort_order' => $next_order,
                                                ])
                                            </span>
                                        </a>
                                    </th>
                                    <th class="py-3 px-6">PM</th>
                                </tr>
                            </thead>
                            <tbody class="text-gray-600 text-xs">
                                @if ($projects->count())
                                    @foreach ($projects as $index => $project)
                                        @php
                                            $provider = '';
                                            if (!empty($project->joint_provider)) {
                                                $provider = $project->joint_provider->jp_code;
                                            }
                                            
                                            if (!empty($project->educational_partner_1)) {
                                                if (!empty($provider)) {
                                                    $provider .= ' / ';
                                                }
                                            
                                                $provider .= $project->educational_partner_1->ep_code;
                                            }
                                            
                                            $cr_code = '';
                                            
                                            if (!empty($project->jp_cr_code)) {
                                                $cr_code = $project->jp_cr_code;
                                            }
                                            
                                            if (!empty($project->ep_cr_code_1)) {
                                                if (!empty($cr_code)) {
                                                    $cr_code .= ' / ';
                                                }
                                            
                                                $cr_code .= $project->ep_cr_code_1;
                                            }
                                            
                                            $expired_in_days = '';
                                            if (!empty($project->expiration_date)) {
                                                $expiration_date = Carbon\Carbon::parse($project->expiration_date);
                                                $expired_in_days = $expiration_date->diffInDays(today());
                                            }
                                            
                                            $managedby = '';
                                            if (!empty($project->managedby)) {
                                                $managedby = $project->managedby->initials;
                                            }
                                        @endphp

                                        <tr class="border-b border-gray-200 hover:bg-gray-100 font-normal">
                                            <td class="py-2 px-2 text-left whitespace-nowrap">
                                                <div class="flex justify-center">
                                                    {{ $index + $projects->firstItem() }}
                                                </div>
                                            </td>

                                            <td class="py-2 px-2 text-left whitespace-nowrap">
                                                <div class="flex justify-center">
                                                    {{ $project->activity_id }}
                                                </div>
                                            </td>

                                            <td class="py-2 px-2 text-left whitespace-nowrap">
                                                <div class="flex justify-center">
                                                    {{ $project->project_code }}
                                                </div>
                                            </td>

                                            <td class="py-2 px-2 text-left whitespace-nowrap">
                                                <div class="flex justify-center">
                                                    {{ $cr_code }}
                                                </div>
                                            </td>

                                            <td class="py-2 px-2 text-left whitespace-nowrap">
                                                <div class="flex justify-center">
                                                    {{ $provider }}
                                                </div>
                                            </td>

                                            <td class="py-2 px-2 text-left whitespace-nowrap">
                                                <x-utilities.tooltip text="{{ $project->activity_title }}">
                                                    <div class="flex justify-center">
                                                        {!! Str::words($project->activity_title, 2, ' ....') !!}
                                                    </div>
                                                </x-utilities.tooltip>
                                            </td>

                                            <td class="py-2 px-2 text-left whitespace-nowrap">
                                                <x-utilities.tooltip text="{{ $project->activity_type }}">
                                                    <div class="flex justify-center">
                                                        {!! Str::words($project->activity_type, 2, ' ....') !!}
                                                    </div>
                                                </x-utilities.tooltip>
                                            </td>

                                            <td class="py-2 px-2 text-left whitespace-nowrap">
                                                <div class="flex justify-center">
                                                    {{ $project->accreditation_type_4_ipce }}
                                                </div>
                                            </td>

                                            <td class="py-2 px-2 text-left whitespace-nowrap">
                                                <div class="flex justify-center">
                                                    {{ date('m/d/Y', strtotime($project->start_date)) }}
                                                </div>
                                            </td>

                                            <td class="py-2 px-2 text-left whitespace-nowrap">
                                                <div class="flex justify-center">
                                                    {{ date('m/d/Y', strtotime($project->expiration_date)) }}
                                                </div>
                                            </td>

                                            <td class="py-2 px-2 text-left whitespace-nowrap">
                                                <div class="flex justify-center">
                                                    {{ $expired_in_days }}
                                                </div>
                                            </td>

                                            <td class="py-2 px-2 text-left whitespace-nowrap">
                                                <div class="flex justify-center">
                                                    {{ $managedby }}
                                                </div>
                                            </td>
                                        </tr>
                                    @endforeach
                                @else
                                    <tr class="text-gray-700 ">
                                        <td colspan="5" class="px-4 py-3 text-center">
                                            No Data Found
                                        </td>
                                    </tr>
                                @endif
                            </tbody>
                        </table>
                        @include('backend.share.pagination', ['data' => $projects])
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection