@extends('Training::backend.layouts.app')

@section('title', 'Training History')

@push('css')
    <link href="{{ asset('assets/admin/plugins/datatables/dataTables.bootstrap4.min.css') }}" rel="stylesheet"
          type="text/css"/>
    <link href="{{ asset('assets/admin/plugins/select2/select2.min.css') }}" rel="stylesheet" type="text/css">
@endpush

@section('content')
    <!-- Page Content-->
    <div class="page-content-tab">
        <div class="container-fluid">
            <!-- Page-Title -->
            <div class="row">
                <div class="col-sm-12">
                    <div class="page-title-box">
                        <h4 class="page-title">Training History</h4>
                    </div>
                    <!--end page-title-box-->
                </div>
                <!--end col-->
            </div>
            <!--end row-->
            <!-- end page title end breadcrumb -->
            <div class="row">
                <div class="col-sm-12">
                    <div class="card">
                        <div class="card-body">
                            <h4 class="mt-0 mb-0 header-title">Filter</h4>
                            <form method="GET" class="form-horizontal form-wizard-wrapper"
                                  action="{{ route('admin.training.history_report.index') }}">
                                <div class="row">
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase">Name</label>
                                            <input type="text" class="form-control" name="name"
                                                   value="{{ request()->name }}" placeholder="Name">
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase">Phone</label>
                                            <input type="text" class="form-control" name="phone"
                                                   value="{{ request()->phone }}" placeholder="Phone">
                                        </div>
                                    </div>
                                    <div class="col-4">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase">Area Name</label>
                                            <select name="job_area" class="select2 form-control mb-3 custom-select">
                                                <option selected disabled value="">Select Job Area</option>
                                                @foreach($job_areas as $area)
                                                <option {{ (request()->job_area == $area->id) ? 'selected' : '' }} value="{{ $area->id ?? '' }}">{{ $area->name ?? '' }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-4">
                                        <div class="form-group">
                                            <a href="{{ route('admin.training.history_report.index') }}"
                                               class="btn btn-danger waves-effect waves-light mt-4 mr-2">
                                                <i class="ti-reload mr-2"></i>Clear 
                                            </a>
                                            <button type="submit" class="btn btn-primary waves-effect waves-light mt-4">
                                                <i class="ti-search mr-2"></i>Filter Now
                                            </button>
                                        </div>
                                    </div>
                                </div>
                            </form>
                            <!--end form-->
                        </div>
                        <!--end card-body-->
                    </div>
                    <!--end card-->
                </div>
                <!--end col-->
            </div>
            <div class="row">
                <div class="col-sm-12">
                    <div class="card">
                        <div class="card-body">
                            <div class="row">
                                <div class="col-lg-6 col-sm-6">
                                    <h4 class="mt-0 mb-0 header-title">Lists </h4>
                                </div>
                                
                            </div>                            
                            <div class="table-responsive">
                                <table id="datatable" class="table table-bordered dt-responsive nowrap w-100">
                                    <thead>
                                    <tr>
                                        <th rowspan="2">##</th>
                                        <th style="width:100px;" rowspan="2">Date</th>
                                        <th rowspan="2">Name</th>
                                        <th rowspan="2">Mobile no</th>
                                        <th rowspan="2">Department</th>
                                        <th rowspan="2">Designation</th>
                                        <th rowspan="2">Area Name</th>
                                        @foreach($tests as $test)
                                        <th colspan="2">{{$test->name ?? ''}}</th>
                                        @endforeach
                                    </tr>
                                    <tr>
                                        @foreach($tests as $test)
                                        <th>Yes/No</th>
                                        <th>Score</th>
                                        @endforeach
                                    </tr>
                                    </thead>
                                    <tbody>

                                        @foreach($trainee_list as $trainee)
                                           
                                            <tr>
                                                <th>{{ $loop->iteration ?? '' }}</th>
                                                <th>{{ \Carbon\Carbon::parse($trainee->completed_at)->format('d-M-Y H:i') ?? '' }}</th>
                                                <th>{{ $trainee->name ?? '' }}</th>
                                                <th>{{ $trainee->phone ?? '' }}</th>
                                                <th>{{ $trainee->department_name ?? '' }}</th>
                                                <th>{{ $trainee->designation_name ?? '' }}</th>
                                                <th>{{ $trainee->area_name ?? '' }}</th>
                                                
                                                @foreach($tests as $test)
                                                @php
                                                    $data = App\Modules\Training\Models\TrTestParticipant::where('selected_candidate_id', $trainee->candidate->selectedCandidate->id)->get();
                                                    $istest = '';
                                                    $result = 0;
                                                    foreach($data as $val){
                                                        $testschedule = App\Modules\Training\Models\TrTestSchedule::where('id', $val->tr_test_schedule_id)->first();
                                                        if($testschedule->trTest->id == $test->id){
                                                            $istest = 'Yes';
                                                            $result = $val->trRating->percentage ?? '';
                                                        }else{
                                                            $istest = 'No';
                                                            $result = 0;
                                                        }
                                                    }
                                                @endphp
                                                    <th>{{ $istest ?? '' }}</th>
                                                    <th>{{ $result ?? ''}}</th>
                                                @endforeach
                                            </tr>
                                        @endforeach
                                   
                                    </tbody>
                                </table>
                                {{ $trainee_list->links() ?? '' }} Total Record show: {{ $trainee_list->total() }}
                            </div>
                        </div><!--end card-body-->
                    </div><!--end card-->
                </div><!--end col-->
            </div><!--end row-->
        </div>
        <!-- footer -->
    @include('admin.sections.footer')
    <!--end footer-->
    </div>
    <!-- end page content -->
@endsection

@push('js')
    <script src="{{ asset('assets/admin/plugins/datatables/jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('assets/admin/plugins/datatables/dataTables.bootstrap4.min.js') }}"></script>
    
    
@endpush