@extends('admin.layouts.admin')
@section('style')
    <link href="{{ asset('assets/admin/plugins/datatables/dataTables.bootstrap4.min.css') }}" rel="stylesheet"
          type="text/css"/>
@endsection
@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">Recruitment Activity Log</h4>
                    </div>
                    <!--end page-title-box-->
                </div>
                <!--end col-->
            </div>
            <!--end row-->

            <!-- end page title end breadcrumb -->

            @if(session('alert-green'))
                <div class="alert alert-success mt-3 text-center">
                    {{ session('alert-green') }}
                </div>
            @endif

            @if(session('alert-danger'))
                <div class="alert alert-danger mt-3 text-center">
                    {{ session('alert-danger') }}
                </div>
            @endif
            @if($errors->any())
                <div class="row">
                    <div class="col-md-12 mb-5">
                        @foreach ($errors->all() as $error)
                            <div class="text-danger small mb-1">* {{$error}}</div>
                        @endforeach
                    </div>
                </div>
            @endif


            {{ session('status') }}

            <div class="row">
                <div class="col-sm-12">
                    <div class="card">
                        <div class="card-body">
                            
                            <form class="form-horizontal form-wizard-wrapper" method="GET"
                                  class="form-horizontal form-wizard-wrapper"
                                  action="{{ url('/admin/recruitment-activity') }}">
                                @csrf
                                <div class="row">
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase" for="serialno">Department</label>
                                            <select class="form-control" id="department_id" name="department_id"  >
                                                <option value="">Select Department</option>
                                                @foreach($departments as $department)
                                                <option value="{{ $department->id }}" @if( request()->department_id == $department->id) selected="selected" @else disable="disable" @endif>{{ $department->name ?? '' }}</option>
                                                @endforeach
                                            </select> 
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase" for="serialno">User</label>
                                            <select class="form-control" id="user_id" name="user_id"  >
                                                <option value="">Select User</option>
                                                @foreach($userLists as $userList)
                                                <option value="{{ $userList->id }}" @if( request()->user_id == $userList->id) selected="selected" @else disable="disable" @endif>{{ $userList->name ?? '' }}</option>
                                                @endforeach
                                            </select> 
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase">From Date</label>                                            
                                            <input type="text" class="form-control startdate" name="startdate"
                                                   value="{{ request()->startdate }}" placeholder="From Date">
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase">To Date</label>
                                            
                                            <input type="text" class="form-control enddate" name="enddate"
                                                   value="{{ request()->enddate }}" placeholder="From Date">
                                        </div>
                                    </div>
                                    <div class="col-md-8">
                                        <div class="form-group">
                                            <a href="{{route('admin.recruitment_activity')}}"
                                               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>
                                            <!-- <button type="submit" name="download" value="1"
                                                    class="btn btn-success waves-effect waves-light mt-4 mr-2"><i
                                                    class="fas fa-download"></i> Download as Excel
                                            </button> -->
                                        </div>
                                    </div>
                                </div>
                            </form>
                            <!--end form-->
                        </div>
                        <!--end card-body-->
                    </div>
                    <!--end card-->
                </div>
                <!--end col-->
            </div>
            <!--end row-->

            {{ session('message') }}
            <div class="row">
                <div class="col-sm-12">
                    <div class="card">
                        <div class="card-body">
                            <div class="table-responsive">
                                <table id="datatable" class="table table-bordered dt-responsive nowrap w-100">
                                    <thead>
                                    <tr>
                                        <th>User</th>
                                        <th>Department</th>
                                        <th>Job Circular</th>
                                        <th>CV Sorting</th>
                                        <th>Written</th>
                                        <th>Viva</th>
                                        <th>Viva Shortlist</th>
                                        <th>Total</th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                    @if(isset($data) && count($data) > 0)
                                        @foreach($data as $key => $log)
                                        @php ($first = true) @endphp                                            
                                                <tr>      
                                                @if($first = true)                                          
                                                    <td rowspan="{{ ($log['department_count'] + 1) ?? ''}}">{{ $log['user'] ?? '' }}</td>
                                                    @php ($first = false) @endphp
                                                @endif
                                                @php 
                                                    $i = 0; 
                                                    $total_job_Circular = 0;
                                                    $total_cv_Shorting = 0;
                                                    $total_written = 0;
                                                    $total_viva = 0;
                                                    $total_viva_Shortlist = 0;
                                                    $final = 0;
                                                @endphp
                                                @foreach($log['department'] as $depart)
                                                @php                                                      
                                                    $total_job_Circular += ($depart['logs']['job_Circular'] > 0) ? $depart['logs']['job_Circular'] : 0;
                                                    $total_cv_Shorting += ($depart['logs']['cv_Shorting'] > 0) ? $depart['logs']['cv_Shorting'] : 0 ;
                                                    $total_written += ($depart['logs']['written'] > 0) ? $depart['logs']['written'] : 0;
                                                    $total_viva += ($depart['logs']['viva'] > 0) ? $depart['logs']['viva'] : 0;
                                                    $total_viva_Shortlist += ($depart['logs']['viva_Shortlist'] > 0) ? $depart['logs']['viva_Shortlist'] : 0;
                                                    $i = (($depart['logs']['job_Circular'] > 0) ? $depart['logs']['job_Circular'] : 0) + (($depart['logs']['cv_Shorting'] > 0) ? $depart['logs']['cv_Shorting'] : 0) + (($depart['logs']['written'] > 0) ? $depart['logs']['written'] : 0) + (($depart['logs']['viva'] > 0) ? $depart['logs']['viva'] : 0) + (($depart['logs']['viva_Shortlist'] > 0) ? $depart['logs']['viva_Shortlist'] : 0);
                                                    $final += $i;
                                                @endphp
                                                    <td>{{ $depart['department'] }}</td>
                                                    <td>{{ isset($depart['logs']['job_Circular']) ? (($depart['logs']['job_Circular'] > 0) ? $depart['logs']['job_Circular'] : 0) : 0 }}</td>
                                                    <td>{{ ($depart['logs']['cv_Shorting'] > 0) ? $depart['logs']['cv_Shorting'] : 0  }}</td>
                                                    <td>{{ ($depart['logs']['written'] > 0) ? $depart['logs']['written'] : 0 }}</td>
                                                    <td>{{ ($depart['logs']['viva'] > 0) ? $depart['logs']['viva'] : 0 }}</td>
                                                    <td>{{ ($depart['logs']['viva_Shortlist'] > 0) ? $depart['logs']['viva_Shortlist'] : 0 }}</td>
                                                    <td>{{ $i }}</td>                                                    
                                                </tr>
                                                
                                            @endforeach   
                                            <tr>
                                                <td style="font-weight:bold">Total</td>                                                
                                                <td style="font-weight:bold">{{ $total_job_Circular ?? '' }}</td>                                                
                                                <td style="font-weight:bold">{{ $total_cv_Shorting }}</td>                                                
                                                <td style="font-weight:bold">{{ $total_written }}</td>                                                
                                                <td style="font-weight:bold">{{ $total_viva }}</td>                                                
                                                <td style="font-weight:bold">{{ $total_viva_Shortlist }}</td>                                                
                                                <td style="font-weight:bold">{{ $final ?? '' }}</td>                                                
                                            </tr>
                                        @endforeach
                                    @else
                                        <tr>
                                            <td colspan="7" class="text-center"><h4>No Records Found.</h4></td>
                                        </tr>
                                    @endif 
                                        <!-- <tr>
                                            <td rowspan="2">Md. Alamgir Hossan</td>
                                            <td>Field Force</td>
                                            <td>4</td>
                                            <td>677</td>
                                            <td>633</td>
                                            <td>362</td>
                                            <td>45</td>
                                            <td>1721</td>     
                                        </tr>
                                        <tr>
                                            <td style="font-weight:bold">Total</td>                                                
                                            <td>4</td>
                                            <td>677</td>
                                            <td>633</td>
                                            <td>362</td>
                                            <td>45</td>
                                            <td>1721</td>                                                
                                        </tr>
                                        <tr>
                                            <td rowspan="2">Nazmus Sakib</td>
                                            <td>Field Force</td>
                                            <td>9</td>
                                            <td>120</td>
                                            <td>79</td>
                                            <td>32</td>
                                            <td>23</td>
                                            <td>263</td>     
                                        </tr>
                                        <tr>
                                            <td style="font-weight:bold">Total</td>                                                
                                            <td>9</td>
                                            <td>120</td>
                                            <td>79</td>
                                            <td>32</td>
                                            <td>23</td>
                                            <td>263</td>                                               
                                        </tr> -->
                                    </tbody>
                                </table>
                            </div>
                        </div>
                        <!--end card-body-->
                    </div>
                    <!--end card-->
                </div>
                <!--end col-->
            </div>
            <!--end row-->
        </div>
        <!-- container -->
    @include('admin.sections.footer')
    <!--end footer-->
    </div>
    <!-- end page content -->
@endsection
@section('script')
<script>
    $(document).ready(function () {         
        $('.startdate').datepicker();
        $('.enddate').datepicker();
    });
</script>
@endsection