@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.rota_plan_report') }}</h2>
            <div class="breadcrumb-wrapper">
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="home">{{ trans('master/master.home') }}</a>
                    </li>
                    <li class="breadcrumb-item active">{{ trans('master/master.rota_plan') }}
                    </li>
                </ol>
            </div>
        </div>
    </div>
@endpush
@section('content')
    <!-- Column Search -->
    <section id="column-search-datatable">

        <!-- Filters -->
        <form>
            <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">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 mb-2" for="area_id">{{ trans('master/master.date') }}</label>
                        <div class="header-right d-flex align-items-center mt-sm-0 mt-1">
                            <input type="text" value="{{ $date }}" id="date"
                                class="form-control flatpickr-basic" placeholder="YYYY-MM-DD" name="date">
                        </div>

                        <label class="form-label mt-2" for="area_id">{{ trans('master/master.department') }}</label>
                        <select class="form-control select2" name="department_ids[]" id="department_ids" multiple>
                            @foreach ($filterDepartments as $department)
                                <option value="{{ $department->id }}" @if (in_array($department->id, request()->input('department_ids', []))) selected @endif>
                                    {{ $department->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_ids[]" id="designation_ids" multiple>
                            @foreach ($filterDesignations as $designation)
                                <option value="{{ $designation->id }}" @if (in_array($designation->id, request()->input('designation_ids', []))) selected @endif>
                                    {{ $designation->name }}</option>
                            @endforeach
                        </select>

                        <label class="form-label mt-2" for="area_id">{{ trans('master/master.shift') }}</label>
                        <select class="form-control select2" name="shift_ids[]" id="shift_ids" multiple>
                            @foreach ($filterShifts as $shift)
                                <option value="{{ $shift->id }}" @if (in_array($shift->id, request()->input('shift_ids', []))) selected @endif>
                                    {{ $shift->name }}</option>
                            @endforeach
                        </select>

                        <label class="form-label mt-2" for="area_id">{{ trans('master/master.contractor') }}</label>
                        <select class="form-control select2" name="contractor_ids[]" id="contractor_ids" multiple>
                            @foreach ($filterContractors as $contractor)
                                <option value="{{ $contractor->id }}" @if (in_array($contractor->id, request()->input('contractor_ids', []))) selected @endif>
                                    {{ $contractor->name }}</option>
                            @endforeach
                        </select>

                        <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">
            <div class="col-12">
                <div class="card">
                    <div class="card-header d-flex justify-content-end">
                        <a class="dt-button buttons-excel" target="_blank" href="/{!! $alias !!}/rota-plans/export?{{request()->getQueryString()}}" style="display: initial;">
                            <button type="button" class="btn btn-primary waves-effect waves-float waves-light">
                                <span> Excel</span>
                            </button>
                        </a>
                    </div>

                    @foreach ($contractors as $contractor)
                        <div class="table-responsive">
                            <h5 class="text-center" style="font-weight: bold;margin-top: 18px;">{{ $contractor->name }}
                            </h5>
                            <table class="table mb-0 emp_table" id="request1">
                                <thead>
                                    <th></th>
                                    <th></th>

                                    @foreach ($shifts as $shift)
                                        <th class="text-center" colspan="3" style="font-weight:bold;color:#000">
                                            {{ $shift->name }}</th>
                                    @endforeach
                                    <th class="text-center" colspan="3" style="font-weight:bold;color:#000">
                                        {{ trans('master/master.total') }}</th>
                                </thead>
                                <tbody>
                                    <tr>
                                        <td>{{ trans('master/master.department') }}</td>
                                        <td>{{ trans('master/master.designation') }}</td>

                                        @foreach ($shifts as $shift)
                                            <td class="text-nowrap">{{ trans('master/master.planned') }}</td>
                                            <td class="text-nowrap">{{ trans('master/master.present') }}</td>
                                            <td class="text-nowrap">{{ trans('master/master.difference') }}</td>
                                        @endforeach
                                        <td class="text-nowrap">{{ trans('master/master.planned') }}</td>
                                        <td class="text-nowrap">{{ trans('master/master.present') }}</td>
                                        <td class="text-nowrap">{{ trans('master/master.difference') }}</td>

                                    </tr>

                                    @php
                                        $totalArray = [];
                                        
                                    @endphp

                                    @foreach ($departments as $department)
                                        @foreach ($designations as $designation)
                                            <tr>
                                                <td>{{ $department->name }}</td>
                                                <td>{{ $designation->name }}</td>
                                                @php
                                                    $totalPlan = 0;
                                                    $totalPresent = 0;
                                                    $tatalDifference = 0;
                                                    $differenceCount = 0;
                                                @endphp
                                                @foreach ($shifts as $shift)
                                                    @php
                                                        
                                                        $plannedCount = $rotaProcess->getPlanEmployees($organization->id, $contractor->id, $shift->id, $department->id, $date, $designation->id);
                                                        $presentEmps = $rotaProcess->getPresentEmployees($organization, $contractor->id, $shift, $department->id, $date, $designation->id);
                                                        $presentCount = $presentEmps['present_count'];
                                                        $differenceCount = $plannedCount - $presentCount;
                                                        
                                                        if (!isset($totalArray[$shift->id])) {
                                                            $totalArray[$shift->id] = [
                                                                'planned' => 0,
                                                                'present' => 0,
                                                                'diff' => 0,
                                                            ];
                                                        }
                                                        $totalPlan += $plannedCount;
                                                        $totalPresent += $presentCount;
                                                        $tatalDifference += $differenceCount;
                                                        
                                                        $totalArray[$shift->id]['planned'] += $plannedCount;
                                                        $totalArray[$shift->id]['present'] += $presentCount;
                                                        $totalArray[$shift->id]['diff'] += $differenceCount;
                                                        
                                                    @endphp

                                                    <td class="text-nowrap"><a href="/{!! $alias !!}/rota-plans/planed-details?date={{ $date }}&shift_id={{$shift->id}}&contractor_id={{$contractor->id}}&department_id={{$department->id}}&designation_id={{$designation->id}}">{{ $plannedCount }}</a></td>
                                                    <td class="text-nowrap"><a href="/{!! $alias !!}/rota-plans/present-details?date={{ $date }}&shift_id={{$shift->id}}&contractor_id={{$contractor->id}}&department_id={{$department->id}}&designation_id={{$designation->id}}">{{ $presentCount }}</a></td>
                                                    <td class="text-nowrap">{{ $plannedCount - $presentCount }}</td>
                                                @endforeach
                                                <td class="text-nowrap">{{ $totalPlan }}</td>
                                                <td class="text-nowrap">{{ $totalPresent }}</td>
                                                <td class="text-nowrap">{{ $tatalDifference }}</td>

                                            </tr>
                                        @endforeach
                                    @endforeach

                                    <tr>
                                        <td style="font-weight:bold">{{ trans('master/master.total') }}</td>
                                        <td></td>

                                        @php
                                            $totalPlanG = 0;
                                            $totalPresentG = 0;
                                            $tatalDifferenceG = 0;
                                        @endphp

                                        @foreach ($shifts as $shift)
                                            @php
                                                $totalPlanG += $totalArray[$shift->id]['planned'];
                                                $totalPresentG += $totalArray[$shift->id]['present'];
                                                $tatalDifferenceG += $totalArray[$shift->id]['diff'];
                                            @endphp
                                            <td class="sum_contractor_plan_emp{{ $loop->iteration }}"
                                                style="font-weight:bold">
                                                {{ $totalArray[$shift->id]['planned'] }}
                                            </td>
                                            <td class="sum_contractor_present_emp{{ $loop->iteration }}"
                                                style="font-weight:bold">
                                                {{ $totalArray[$shift->id]['present'] }}
                                            </td>
                                            <td class="sum_contractor_absent_emp{{ $loop->iteration }}"
                                                style="font-weight:bold">
                                                {{ $totalArray[$shift->id]['diff'] }}
                                            </td>
                                        @endforeach

                                        <td class="total_sum_plan_emp" style="font-weight:bold">{{ $totalPlanG }}</td>
                                        <td class="total_sum_present_emp" style="font-weight:bold">{{ $totalPresentG }}
                                        </td>
                                        <td class="total_sum_absent_emp" style="font-weight:bold">{{ $tatalDifferenceG }}
                                        </td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                    @endforeach

        {{-- all contractor total --}}
                    {{-- <div class="table-responsive">
                        <h5 class="text-center" style="font-weight: bold">{{ trans('master/master.all_contractor') }}
                        </h5>
                        <table class="table mb-0 emp_table" id="request1">
                            <thead>
                                <th scope="col" class="text-nowrap"></th>
                                <th scope="col" class="text-nowrap"></th>

                                @foreach ($shifts as $shift)
                                    <th class="text-center" colspan="3" style="font-weight:bold;color:#000">
                                        {{ $shift->name }}</th>
                                @endforeach
                                <th class="text-center" colspan="3" style="font-weight:bold;color:#000">
                                    {{ trans('master/master.total') }}</th>
                            </thead>
                            <tbody>
                                <tr>
                                    <td class="text-nowrap">{{ trans('master/master.department') }}</td>
                                    <td class="text-nowrap">{{ trans('master/master.designation') }}</td>
                                    @foreach ($shifts as $shift)
                                        <td class="text-nowrap">{{ trans('master/master.planned') }}</td>
                                        <td class="text-nowrap">{{ trans('master/master.present') }}</td>
                                        <td class="text-nowrap">{{ trans('master/master.difference') }}</td>
                                    @endforeach
                                    <td class="text-nowrap">{{ trans('master/master.planned') }}</td>
                                    <td class="text-nowrap">{{ trans('master/master.present') }}</td>
                                    <td class="text-nowrap">{{ trans('master/master.difference') }}</td>

                                </tr>

                                @php
                                    $totalContractorArray = [];
                                    
                                @endphp
                                @foreach ($departments as $department)
                                    @foreach ($designations as $designation)
                                        <tr>
                                            <td>{{ $department->name }}</td>
                                            <td>{{ $designation->name }}</td>
                                            @php
                                                $totalPlan = 0;
                                                $totalPresent = 0;
                                                $tatalDifference = 0;
                                                $differenceCount = 0;
                                            @endphp
                                            @foreach ($shifts as $shift)
                                                @php
                                                    $plannedCount = $rotaProcess->getPlanEmployees($organization->id, $contractor->id, $shift->id, $department->id, $designation->id, $date);
                                                    $presentCount = $rotaProcess->getPresentEmployees($organization->id, $contractor->id, $shift->id, $department->id, $designation->id, $date);
                                                    $differenceCount = $plannedCount - $presentCount;
                                                    
                                                    if (!isset($totalContractorArray[$contractor->id])) {
                                                        $totalArray[$contractor->id] = [
                                                            'contractorPlanned' => 0,
                                                            'contractorPresent' => 0,
                                                            'contractorDiff' => 0,
                                                        ];
                                                    }
                                                    
                                                @endphp

                                                <td class="text-nowrap"></td>
                                                <td class="text-nowrap"></td>
                                                <td class="text-nowrap"></td>
                                            @endforeach
                                            <td class="text-nowrap"></td>
                                            <td class="text-nowrap"></td>
                                            <td class="text-nowrap"></td>

                                        </tr>
                                    @endforeach


                                    <tr>
                                        <td style="font-weight:bold">{{ trans('master/master.total') }}</td>
                                        <td class="text-nowrap"></td>


                                        @foreach ($shifts as $shift)
                                            <td class="text-nowrap sum_contractor_plan_emp{{ $loop->iteration }}"
                                                style="font-weight:bold"></td>
                                            <td class="text-nowrap sum_contractor_present_emp{{ $loop->iteration }}"
                                                style="font-weight:bold"></td>
                                            <td class="text-nowrap sum_contractor_absent_emp{{ $loop->iteration }}"
                                                style="font-weight:bold"></td>
                                        @endforeach

                                        <td class="text-nowrap total_sum_plan_emp" style="font-weight:bold"></td>
                                        <td class="text-nowrap total_sum_present_emp" style="font-weight:bold"></td>
                                        <td class="text-nowrap total_sum_absent_emp" style="font-weight:bold"></td>
                                    </tr>
                                @endforeach

                            </tbody>
                        </table>
                    </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>
        $(function(){
            $('.select2').select2();
        })
    </script>
@endpush