@extends('app-new')
@push('head-script')
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/tables/datatable/dataTables.bootstrap5.min.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/tables/datatable/responsive.bootstrap5.min.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/css/components.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/vendors.min.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/extensions/toastr.min.css">
    
    <!-- BEGIN: Page CSS-->
    <link rel="stylesheet" type="text/css" href="/app-assets/css/core/menu/menu-types/vertical-menu.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/css/plugins/forms/pickers/form-flat-pickr.css">
    <!-- END: Page CSS-->
    
@endpush 

@push('content-header')
    <div class="row breadcrumbs-top">
        <div class="col-12">
            <h2 class="content-header-title float-start mb-0">{{trans('master/master.monthly_performance_report')}}</h2>
            <div class="breadcrumb-wrapper">
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="home">{{trans('common/common.home')}}</a>
                    </li>
                    <li class="breadcrumb-item active">{{trans('master/master.performance_register')}}
                    </li>
                </ol>
            </div>
        </div>
    </div>
@endpush
@section('content')
    <!-- Column Search -->
    <section id="column-search-datatable">

        <!-- Filters -->
    <form action="{{ "$orgUrl/attendance-report/performance-register" }}" id="filter-form" method="GET">
    <input type="hidden" id="filename" value="{{$organization->name}} Performance Register - {{$month_name}} {{$year_id}}">
    <input type="hidden" id="organization_name" value="{{$organization->name}}">
    <input type="hidden" id="month_name" value="{{$month_name}}">
    <input type="hidden" id="year_id" value="{{$year_id}}">
    <input type="hidden" id="sublocation_selected_id" value="{{json_encode($subLocationIds)}}">

    <div class="content-header row">
        <div class="content-header-left col-md-9 col-12 mb-2">
            <div class="row breadcrumbs-top">
                <div class="col-12">
                    <h2 class="content-header-title float-start mb-0"></h2>
                    
                </div>
            </div>
        </div>
        <div class="content-header-right text-md-end col-md-3 col-12 d-md-block d-none">
            <div class="mb-1 breadcrumb-right">
                <div class="dropdown">
                    <button class="btn-icon btn btn-primary btn-round btn-sm dropdown-toggle" type="button"
                        data-bs-toggle="offcanvas" data-bs-target="#offcanvasEnd" aria-controls="offcanvasEnd"
                        type="button"><i data-feather='filter'></i></button>
                </div>
            </div>
        </div>
    </div>
    
    <div class="offcanvas-end-example">
                <div class="offcanvas offcanvas-end" tabindex="-1" id="offcanvasEnd" aria-labelledby="offcanvasEndLabel">
                <div class="offcanvas-header">
                    <h5 id="offcanvasEndLabel" class="offcanvas-title">{{trans('common/common.filter')}}</h5>
                    <button type="button" class="btn-close text-reset" data-bs-dismiss="offcanvas"
                        aria-label="Close"></button>
                </div>
                <div class="offcanvas-body my-auto mx-0 flex-grow-0">
                    <label class="form-label mt-2" for="area_id">{{trans('common/common.month')}}</label>
                    <select class="form-control select2" name="month_id" id="month_id">
                        @foreach ($month as $mkey=>$monthitem)
                            <option value="{{$mkey}}" @if(($mkey == $month_id) || (old('month_id') == $mkey)) selected @endif>{{$monthitem}}</option>
                        @endforeach
                    </select>
                    <label class="form-label mt-2" for="area_id">{{trans('common/common.year')}}</label>
                    <select class="form-control select2" name="year_id" id="year_id">
                       @foreach ($year as $ykey=>$yearitem)
                            <option value="{{$yearitem}}" @if(($yearitem == $year_id) || (old('year_id') == $yearitem)) selected @endif>{{$yearitem}}</option> 
                        @endforeach
                    </select>
                @if(Auth::user()->hasTeam()) 
                    <label class="form-label mt-2" for="area_id">{{trans('master/master.location')}}</label>
                    <select class="form-control select2" name="location_id[]" id="location_id" onchange="getsubLocations(this,'sublocations')" multiple>
                        @foreach($locations as $location)
                            <option value="{{$location->id}}" @if( ($locationIds) && in_array($location->id, $locationIds)) selected @endif>{{$location->name}}
                            </option>
                        @endforeach
                    </select>
                    <label class="form-label mt-2" for="area_id">{{trans('master/master.sub_location')}}</label>
                    <select class="form-control select2" name="sub_location_id[]" id="sub_location_id" multiple>
                       @foreach($subLocations as $subLocation)
                           <option value="{{$subLocation->id}}" @if( ($subLocationIds) && in_array($subLocation->id, $subLocationIds)) selected @endif>{{$subLocation->name}}
                            </option>
                        @endforeach
                    </select>
                    <label class="form-label mt-2" for="area_id">{{trans('master/master.department')}}</label>
                    <select class="form-control select2" name="department_id[]" id="department_id" multiple>
                       @foreach($departments as $department)
                            <option value="{{$department->id}}" @if( ($departmentIds) && in_array($department->id, $departmentIds)) selected @endif>
                                                {{$department->name}}</option>
                        @endforeach
                    </select>
                    <label class="form-label mt-2" for="area_id">{{trans('master/master.sub_department')}}</label>
                    <select class="form-control select2" name="sub_department_id[]" id="sub_department_id" multiple>
                       @foreach($subDepartments as $subDepartment)
                                            <option value="{{$subDepartment->id}}" @if( ($subDepartmentIds) && in_array($subDepartment->id, $subDepartmentIds)) selected @endif>{{$subDepartment->name}}
                                            </option>
                        @endforeach
                    </select>
                    <label class="form-label mt-2" for="area_id">{{trans('master/master.designation')}}</label>
                    <select class="form-control select2" name="designation_id[]" id="designation_id" multiple>
                        @foreach($designations as $designation)
                                            <option value="{{$designation->id}}" @if( ($designationIds) && in_array($designation->id, $designationIds)) selected @endif>
                                                {{$designation->name}}
                                            </option>
                        @endforeach
                    </select>

                    <label class="form-label mt-2" for="area_id">{{trans('master/master.company_code')}}</label>
                    <select class="form-control mb-2 select2" name="company_code_id[]" id="company_code_id" multiple>
                        @foreach($companyCodes as $companyCode)
                            <option value="{{$companyCode->id}}" @if( ($companyCodeIds) && in_array($companyCode->id, $companyCodeIds)) selected @endif>
                                {{$companyCode->number}}
                            </option>
                        @endforeach
                    </select>
                    
                    <label class="form-label mt-2" for="area_id">{{trans('master/master.contractor')}}</label>
                    <select class="form-control select2" name="contractor_id[]" id="contractor_id" multiple>
                       @foreach($contractors as $contractor)
                                            <option value="{{$contractor->id}}" @if( ($contractorIds) && in_array($contractor->id, $contractorIds)) selected @endif>
                                                {{$contractor->name}}
                                            </option>
                        @endforeach
                    </select>
                    <label class="form-label mt-2" for="area_id">{{trans('master/master.employee_type')}}</label>
                    <select class="form-control select2" name="employee_type" id="employee_type" onchange="getEmployeeByType(this.value)">
                                       <option value="">Select Type</option>
                                        @foreach($employeeTypes as $empType)
                                            <option value="{{$empType}}" @if($empType == $employeeTypeSelected) selected @endif>
                                                {{ucwords($empType)}}
                                            </option>
                                        @endforeach
                    </select>
                    <label class="form-label mt-2" for="area_id">{{trans('master/master.employees')}}</label>
                    <select class="form-control select2" name="employee_id[]" id="employee_id" multiple>
                    </select>
                @endif
                    <button type="submit" class="btn btn-primary mt-2 mb-1 d-grid w-100 d-flex justify-content-center" data-bs-dismiss="offcanvas" aria-label="Close"><i
                            data-feather='search' class="me-2"></i> {{trans('common/common.search')}}</button>
                </div>
            </div>
        </div>
  </form>
    <!-- // Filters // -->

    <div class="row" id="table-responsive">
  <div class="col-12">
    <div class="card">
        <div class="card-header d-flex justify-content-end">
            <div class="dropdown">
                <a class="btn btn-primary dropdown-toggle" href="#" role="button" id="dropdownMenuLink"
                    data-bs-toggle="dropdown" aria-expanded="false">
                    Export
                </a>
                <ul class="dropdown-menu" aria-labelledby="dropdownMenuLink">
                    <li>
                        <a target="_blank"
                            href="{{ $orgUrl }}/attendance-report/performance-register?{{ http_build_query(array_merge(request()->query(), ['type' => 'pdf'])) }}"
                            class="dropdown-item">
                            <span>PDF</span>
                        </a>
                    </li>
                    <li>
                        <a target="_blank"
                            href="{{ $orgUrl }}/attendance-report/performance-register?{{ http_build_query(array_merge(request()->query(), ['type' => 'excel'])) }}"
                            class="dropdown-item">
                            <span>Excel</span>
                        </a>
                    </li>
                    <li>
                        <a target="_blank"
                            href="{{ $orgUrl }}/attendance-report/performance-register?{{ http_build_query(array_merge(request()->query(), ['type' => 'csv'])) }}"
                            class="dropdown-item">
                            <span>CSV</span>
                        </a>
                    </li>
                </ul>
            </div>
        </div>
        <div class="card-body">
        </div>
        <div class="table-responsive">
            <table class="table mb-0">
                <tbody>
                    @foreach($attendanceSummary as $value)
                        @php
                            $tolalDays = count($dateArr);
                            $value->load(['vwAttendanceSummary' =>  function($q) use($month_id, $year_id){
                                $q->where('month', '=', $month_id)
                                ->where('year', '=', $year_id);
                            }]);
                        @endphp
                        

                        <tr style="background-color:rgb(4, 23, 49); color:white; border-top: 5px solid transparent;">
                            <td class="text-nowrap" colspan="{{(count($dateArr))/2}}">
                                <div style="background-color:rgb(4, 23, 49);" class="d-inline-block">
                                    <strong>{{trans('master/master.name')}}:</strong>: 
                                    {{$value->name}} 
                                    <span class="employeecodereport">
                                        ( {{$value->employee_code}} )
                                    </span> &emsp;
                                    <strong>{{trans('master/master.employee_type')}}:</strong> 
                                    {{ucwords($value->employee_type)}}
                                </div>
                            </td>
                            
                            <td class="text-nowrap" colspan="{{((count($dateArr))/2) +1}}" class="text-right">
                                @if(!empty($value->vwAttendanceSummary))
                                <strong>{{trans('master/master.present')}}</strong>: {{ $value->vwAttendanceSummary->total_present }} &emsp;
                                <strong>{{trans('master/master.absent')}}</strong>: {{ $value->vwAttendanceSummary->total_absent }} &emsp;
                                <strong>{{trans('master/master.leave')}}</strong>: {{ $value->vwAttendanceSummary->total_leave }} &emsp;
                                <strong>{{trans('master/master.holiday')}}</strong>: {{ $value->vwAttendanceSummary->total_holiday }} &emsp;
                                <strong>{{trans('master/master.week_off')}}</strong>: {{ $value->vwAttendanceSummary->total_week_off }} &emsp;
                                <strong>{{ trans('master/master.paid_leave') }}</strong>: {{ $value->vwAttendanceSummary->paid_leave ?? 0}} &emsp;
                                <strong>{{ trans('master/master.unpaid_leave') }}</strong>: {{ $value->vwAttendanceSummary->unpaid_leave ?? 0}} &emsp;
                                <strong>{{ trans('master/master.fine_days') }}</strong>: {{ round(@$value->vwAttendanceSummary->total_fine_days) }} &emsp;
                                <strong>{{trans('attendance/admin.working_hours')}}</strong>: {{ round($value->vwAttendanceSummary->total_working_time, 2) }} &emsp; 
                                <strong>{{trans('master/master.actual_ot_hours')}}</strong>: {{ round((@$value->vwAttendanceSummary->actual_overtime ?: 0), 2 )}} &emsp;
                                <strong>{{trans('master/master.approved_ot_hours')}}</strong>: {{ round($value->vwAttendanceSummary->total_overtime, 2 )}} &emsp;
                                <strong>{{trans('master/master.ot')}} % </strong>: {{ ($value->vwAttendanceSummary->total_overtime >0 &&  $value->vwAttendanceSummary->total_working_time > 0) ? round( ($value->vwAttendanceSummary->total_overtime / $value->vwAttendanceSummary->total_working_time)*100 ,2) : 0 }}% &emsp;
                                <strong>{{trans('master/master.productive_hour')}} </strong>: 
                                {{ round((@$value->vwAttendanceSummary->total_productive_hours ?: 0), 2 )}} &emsp;
                                @endif
                            </td>
                        </tr>
                        <tr>
                            <td class="text-nowrap"></td>
                            @foreach($dateArr as $dates)
                                <td class="text-nowrap">{{date('d', strtotime($dates))}}</td>
                            @endforeach
                        </tr>
                        <tr>
                            @php
                                $atSummary = $value->getAttendanceSummaryList($month_id, $year_id);
                            @endphp
                            <td class="text-nowrap"><strong>{{trans('master/master.in')}}: </strong></td>
                            @foreach($dateArr as $date)
                                @if(!isset($atSummary[$date]))

                                <td>
                                    -
                                </td>

                                @continue;

                                @endif
                                @php 
                                    $attendance = isset($atSummary[$date]) ? $atSummary[$date] : NULL;
                                @endphp
                                <td class="text-nowrap">{{ ($attendance->in_time) ? date('H:i',strtotime($attendance->in_time)) : '-' }}</td>
                            @endforeach
                        </tr>
                        <tr>
                            <td class="text-nowrap"><strong>{{trans('master/master.out')}}: </strong></td>
                            @foreach($dateArr as $date)
                                @if(!isset($atSummary[$date]))

                                <td>
                                    -
                                </td>

                                @continue;

                                @endif
                                
                                @php 
                                    $attendance = isset($atSummary[$date]) ? $atSummary[$date] : NULL;
                                @endphp
                                <td class="text-nowrap">{{( $attendance->out_time) ? date('H:i',strtotime($attendance->out_time)) : '-' }}</td>
                                
                            @endforeach
                        </tr>
                        <tr>
                            <td class="text-nowrap"><strong>{{trans('attendance/admin.working_hours')}}: </strong></td>
                            @foreach($dateArr as $date)
                    
                                @if(!isset($atSummary[$date]))

                                <td>
                                    -
                                </td>

                                @continue;

                                @endif
                                
                                @php 
                                    $attendance = isset($atSummary[$date]) ? $atSummary[$date] : NULL;
                                @endphp
                                <td class="text-nowrap">{{ ($attendance->working_time && $attendance->working_time !='00:00:00') ? \App\Helpers\GeneralHelper::formatToHi($attendance->working_time) : '-'}}</td>
                            @endforeach
                        </tr>
                        <tr>
                            <td class="text-nowrap"><strong>{{trans('master/master.overtime')}}: </strong></td>
                            @foreach($dateArr as $date)
                                @if(!isset($atSummary[$date]))

                                <td>
                                    -
                                </td>

                                @continue;

                                @endif
                                
                                @php 
                                    $attendance = isset($atSummary[$date]) ? $atSummary[$date] : NULL;
                                @endphp

                                <td class="text-nowrap">{{ ($attendance->overtime && $attendance->overtime !='00:00:00') ? date('H:i',strtotime($attendance->overtime)) : '-'}}</td>
                            @endforeach
                        </tr>
                        <tr>
                            <td class="text-nowrap"><strong>{{trans('master/master.status')}}: </strong></td>
                            @foreach($dateArr as $date)
                                @if(!isset($atSummary[$date]))

                                <td>
                                    -
                                </td>

                                @continue;

                                @endif
                                
                                @php 
                                    $attendance = isset($atSummary[$date]) ? $atSummary[$date] : NULL;
                                    $autoWeekClass = $attendance->remarks == App\Helpers\ConstantHelper::AUTO_WEEK_OFF ? 'autoweekoff' : '' ;

                                    $bgColor = '';
                                    if($attendance->attendance_type == 'leave'  || $attendance->on_duty == 4){
                                        $bgColor = 'bg-light-warning';
                                    }

                                    if($attendance->attendance_type == 'holiday' || $attendance->on_duty == 3){
                                        $bgColor = 'bg-light-primary';
                                    }
                                    
                                    if($attendance->attendance_type == 'week-off' || $attendance->on_duty == 2){
                                        $bgColor = 'bg-light-secondary';
                                    }
                                
                                @endphp
                                <td class="text-nowrap {{$bgColor}} {{ $autoWeekClass }}">
                                    {{$attendance->first_half_status}} 
                                    @if ($attendance->first_half_status == 'L')
                                        ({{ strtoupper($attendance->leave_type)}})
                                    @endif 
                                    <br> 
                                    {{$attendance->second_half_status}} 
                                    @if ($attendance->second_half_status=='L')
                                        ({{ strtoupper($attendance->leave_type) }})
                                    @endif
                                </td>
                                
                            @endforeach
                        </tr>
                        <tr>
                            <td class="text-nowrap" style="background: white"><strong>{{trans('master/master.final_status')}}: </strong></td>
                            @foreach($dateArr as $date)
                                @if(!isset($atSummary[$date]))

                                <td>
                                    -
                                </td>

                                @continue;

                                @endif
                                
                                @php 
                                    $attendance = isset($atSummary[$date]) ? $atSummary[$date] : NULL;
                                    $autoWeekClass = $attendance->remarks == App\Helpers\ConstantHelper::AUTO_WEEK_OFF ? 'autoweekoff' : '' ;

                                    $bgColor = '';
                                    if($attendance->attendance_type == 'leave'  || $attendance->on_duty == 4){
                                        $bgColor = 'bg-light-warning';
                                    }

                                    if($attendance->attendance_type == 'holiday' || $attendance->on_duty == 3){
                                        $bgColor = 'bg-light-primary';
                                    }

                                    if($attendance->attendance_type == 'week-off' || $attendance->on_duty == 2){
                                        $bgColor = 'bg-light-secondary';
                                    }
                                @endphp
                                <td class="text-nowrap {{$bgColor}} {{ $autoWeekClass }}">{{$attendance->status}} @if ($attendance->leave_type)
                                    ({{ strtoupper($attendance->leave_type) }})
                                    @endif</td>
                            @endforeach
                        </tr>
                    @endforeach

                   
                </tbody>

            </table>
            <br>
            {{$attendanceSummary->appends($nextQuery)->links('pagination::bootstrap-4')}}

      </div>
    </div>
  </div>
</div>

    </section>
    <!--/ Column Search -->
@endsection 
@push('footer-script') 
    <!-- BEGIN: Page Vendor JS-->
    <script src="/app-assets/vendors/js/tables/datatable/jquery.dataTables.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/dataTables.bootstrap5.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/dataTables.responsive.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/responsive.bootstrap5.js"></script>
    <script src="/app-assets/vendors/js/pickers/flatpickr/flatpickr.min.js"></script>
    <script src="/app-assets/js/scripts/ui/ui-feather.js"></script>

    <script src="/app-assets/vendors/js/tables/datatable/datatables.checkboxes.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/datatables.buttons.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/jszip.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/pdfmake.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/vfs_fonts.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/buttons.html5.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/buttons.print.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/dataTables.rowGroup.min.js"></script>
    <!-- END: Page Vendor JS-->
    <script src="/app-assets/vendors/js/extensions/toastr.min.js"></script>


    <!-- BEGIN: Page JS-->
    <script src="/app-assets/js/scripts/tables/table-datatables-basic.js"></script>
    <script src="/app-assets/js/scripts/tables/table-datatables-advanced.js"></script>
    <!-- END: Page JS-->
  
  <script>
    var subLocations = $('#sublocation_selected_id').val();
     $(document).ready(function() {

        $('#location_id').show();
        $('#location_id').select2();
        $('#sub_location_id').show();
        $('#sub_location_id').select2();
        $('#department_id').show();
        $('#department_id').select2();
        $('#sub_department_id').show();
        $('#sub_department_id').select2();
        $('#designation_id').show();
        $('#designation_id').select2();
        $('#employee_id').show();
        $('#employee_id').select2();
        $('#manager_id').show();
        $('#manager_id').select2();
        $('#contractor_id').show();
        $('#contractor_id').select2();
        $('#company_code_id').show();
        $('#company_code_id').select2();
        
        if ($('#location_id').val()) {
            getsubLocations();
        }
        $("#searchbox").hide();
        $(".filterbutton").click(function() {
            $("#searchbox").slideToggle('slow'); 
        });
        $('#request11').DataTable({
            "scrollX": "100%",
            "scrollCollapse": true,
            "ordering": false,
            "order": [[ 0, "desc" ]],
            dom: 'Bfrtip',
            buttons: [
                
            ]
        });

        getEmployeeByType("{{ $employeeTypeSelected }}");
    });

    function getEmployeeByType (employee_type) {
        var url = "{!! route('employees--type',['alias'=>$alias]) !!}?employee_type=" + employee_type;
        $.ajax({
            url: url,
            type: "GET",
            success: function (data) {
                op = '';
                for (var i = 0; i < data.length; i++){
                    op += '<option value="'+data[i].id+'">'+data[i].name+'('+data[i].employee_code+')</option>';
                }
                $('#employee_id').html(op);
            }
        });

    }
    
    function getsubLocations(th) {
        var locationId = $('#location_id').val();
        
        var subLocationId = "";

        var data = {
            location_id: locationId,
            '_token': '{{{csrf_token()}}}'
        }
        $.ajax({
            url: '/{!! $alias !!}/location/sub-locations',
            type: 'POST',
            data: data,
            success: function(data) {
                var selectbox = '';
                if (data) {
                    selectbox = '<label for="sub_location_id">Sub Location</label>';
                    selectbox += '<div class="form-label-group"><select name="sub_location_id[]" class="form-control select2" id="sub_location_id" multiple>';
                    $.each(data, function(i, item) {
                        if (subLocations.includes(i)) {
                            selectbox += '<option value="' + i + '" selected="selected">' + item + '</option>';
                        } else {
                            selectbox += '<option value="' + i + '">' + item + '</option>';
                        }
                    });
                    selectbox += '</select></div>';
                }
                $('#sub_location_id').html(selectbox);
                $("#sub_location_id").select2({
                    multiple: true
                });
            }
        });
        
    }

</script>





@endpush