@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 mt-2" for="area_id">{{ trans('admin/template.month') }}</label>
                        <select class="form-control mb-2 select2" name="month" id="month">
                            @foreach ($months as $key => $val)
                                <option class="form-control" value="{{ $key }}"
                                    @if ($key == $month) selected @endif>{{ $val }}</option>
                            @endforeach
                        </select>

                        <label class="form-label mt-2" for="year">{{ trans('admin/template.year') }}</label>
                        <select class="form-control mb-2 select2" name="year" id="year">
                            @foreach ($years as $val)
                                <option class="form-control" value="{{ $val }}"
                                    @if ($val == $year) selected @endif>{{ $val }}</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 !!}/roaster-plans/contractor-wise/report/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>

                    <div class="table-responsive" style="max-height: 750px; overflow-y: scroll;">
                        <table class="table mb-0 table-bordered persumleftfixed">
                            <thead style="position: sticky; z-index: 11; top: 0;">
                                <tr>
                                    <th rowspan="3" style="position: sticky; z-index: 11; left: 0;">Date</th>
                                    @foreach ($contractors as $contractor)
                                        <th class="text-center" colspan="{{ count($shifts) * 2 + 2 }}"
                                            style="font-weight:bold;color:#000000">
                                            {{ $contractor->name }}
                                        </th>
                                    @endforeach
                                </tr>
                                <tr>
                                    @foreach ($contractors as $contractor)
                                        @foreach ($shifts as $key => $shift)
                                            <th class="text-center" colspan="2" style="font-weight:bold;color:#000000">
                                                {{ $shift->name }}
                                            </th>
                                        @endforeach
                                        <th class="text-center" colspan="2" style="font-weight:bold;color:#000000">
                                            Total
                                        </th>
                                    @endforeach
                                </tr>
                                <tr>
                                    @foreach ($contractors as $contractor)
                                        @foreach ($shifts as $key => $shift)
                                            <th class="text-center" style="font-weight:bold;color:#000000">
                                                Short / Excess Variance
                                            </th>
                                            <th class="text-center" style="font-weight:bold;color:#000000">
                                                Late Coming Variance
                                            </th>
                                        @endforeach
                                        <th class="text-center" style="font-weight:bold;color:#000000">
                                            Short / Excess Variance
                                        </th>
                                        <th class="text-center" style="font-weight:bold;color:#000000">
                                            Late Coming Variance
                                        </th>
                                    @endforeach
                                </tr>
                            </thead>
                            <tbody>
                                @php
                                    $totalArr = [];
                                @endphp
                                @foreach ($dates as $date)
                                    <tr>
                                        <td style="font-weight:bold;color:#000000; background-color:rgb(255, 255, 255);" class="text-nowrap">
                                            {{ date('d M', strtotime($date)) }}</td>

                                        @foreach ($contractors as $contractor)
                                            @php
                                                $data = $rotaProcess->getContractorWiseMonthlyEmployeesData($organization, $contractor->id, $month, $year, $shifts, $departments, $designations);
                                            @endphp

                                            @foreach ($shifts as $key => $shift)
                                                @php
                                                    $shortExcessBg = '';
                                                    $lateComingBg = '';

                                                    if (is_numeric($data[$date][$shift->id]['short_excess_variance']) && is_numeric(@$contractor->userDetail->short_excess_variance) && abs($data[$date][$shift->id]['short_excess_variance']) > @$contractor->userDetail->short_excess_variance) {
                                                        if ($data[$date][$shift->id]['short_excess_variance'] < 0) {
                                                            $shortExcessBg = 'bg-light-danger';
                                                        } else {
                                                            $shortExcessBg = 'bg-light-success';
                                                        }
                                                        $totalArr[$contractor->id][$shift->id]['short_excess_variance'] = (@$totalArr[$contractor->id][$shift->id]['short_excess_variance'] ?: 0) + 1;
                                                    }

                                                    if (is_numeric($data[$date][$shift->id]['late_coming_variance']) && is_numeric(@$contractor->userDetail->late_coming_variance) && abs($data[$date][$shift->id]['late_coming_variance']) > @$contractor->userDetail->late_coming_variance) {
                                                        $lateComingBg = 'bg-light-danger';
                                                        $totalArr[$contractor->id][$shift->id]['late_coming_variance'] = (@$totalArr[$contractor->id][$shift->id]['late_coming_variance'] ?: 0) + 1;
                                                    }

                                                    if ($shortExcessBg != '' || $lateComingBg != '') {
                                                        $totalArr[$contractor->id][$shift->id]['total_incidents'] = (@$totalArr[$contractor->id][$shift->id]['total_incidents'] ?: 0) + 1;
                                                    }
                                                @endphp
                                                <td class="text-nowrap {{ $shortExcessBg }}">
                                                    {{ $data[$date][$shift->id]['short_excess_variance'] }} %</td>
                                                <td class="text-nowrap {{ $lateComingBg }}">
                                                    {{ $data[$date][$shift->id]['late_coming_variance'] }} %</td>
                                            @endforeach
                                            @php
                                                $shortExcessBg = '';
                                                $lateComingBg = '';

                                                if (is_numeric($data[$date]['total']['short_excess_variance']) && is_numeric(@$contractor->userDetail->short_excess_variance) && abs($data[$date]['total']['short_excess_variance']) > @$contractor->userDetail->short_excess_variance) {
                                                    if ($data[$date]['total']['short_excess_variance'] < 0) {
                                                        $shortExcessBg = 'bg-light-danger';
                                                    } else {
                                                        $shortExcessBg = 'bg-light-success';
                                                    }
                                                    $totalArr[$contractor->id]['total']['short_excess_variance'] = (@$totalArr[$contractor->id]['total']['short_excess_variance'] ?: 0) + 1;
                                                }

                                                if (is_numeric($data[$date]['total']['late_coming_variance']) && is_numeric(@$contractor->userDetail->late_coming_variance) && abs($data[$date]['total']['late_coming_variance']) > @$contractor->userDetail->late_coming_variance) {
                                                    $lateComingBg = 'bg-light-danger';
                                                    $totalArr[$contractor->id]['total']['late_coming_variance'] = (@$totalArr[$contractor->id]['total']['late_coming_variance'] ?: 0) + 1;
                                                }

                                                if ($shortExcessBg != '' || $lateComingBg != '') {
                                                    $totalArr[$contractor->id]['total']['total_incidents'] = (@$totalArr[$contractor->id]['total']['total_incidents'] ?: 0) + 1;
                                                }
                                            @endphp
                                            <td class="text-nowrap {{ $shortExcessBg }}">
                                                <strong>{{ $data[$date]['total']['short_excess_variance'] }} %</strong>
                                            </td>
                                            <td class="text-nowrap {{ $lateComingBg }}">
                                                <strong>{{ $data[$date]['total']['late_coming_variance'] }} %</strong>
                                            </td>
                                        @endforeach
                                    </tr>
                                @endforeach
                            </tbody>
                            <tfoot style="position: sticky; z-index: 11; bottom: 0; background-color:rgb(255, 255, 255);">
                                <tr>
                                    <td style="font-weight:bold;color:#000000; background-color:rgb(255, 255, 255);" class="text-nowrap">Total Count</td>
                                    @foreach ($contractors as $contractor)
                                        @foreach ($shifts as $key => $shift)
                                            @php
                                                $shortExcessBg = '';
                                                $lateComingBg = '';
                                                $shortExcessG = @$totalArr[$contractor->id][$shift->id]['short_excess_variance'] ?: 0;
                                                $lateComingG = @$totalArr[$contractor->id][$shift->id]['late_coming_variance'] ?: 0;

                                                if (is_numeric(@$contractor->userDetail->short_excess_max_allowed) && $shortExcessG > @$contractor->userDetail->short_excess_max_allowed) {
                                                    $shortExcessBg = 'bg-light-danger';
                                                } else {
                                                    $shortExcessBg = 'bg-light-success';
                                                }

                                                if (is_numeric(@$contractor->userDetail->late_coming_max_allowed) && $lateComingG > @$contractor->userDetail->late_coming_max_allowed) {
                                                    $lateComingBg = 'bg-light-danger';
                                                } else {
                                                    $lateComingBg = 'bg-light-success';
                                                }
                                            @endphp
                                            <td class="text-nowrap {{ $shortExcessBg }}">
                                                {{ $shortExcessG }}</td>
                                            <td class="text-nowrap {{ $lateComingBg }}">
                                                {{ $lateComingG }}</td>
                                        @endforeach
                                        @php
                                            $shortExcessBg = '';
                                            $lateComingBg = '';
                                            $shortExcessG = @$totalArr[$contractor->id]['total']['short_excess_variance'] ?: 0;
                                            $lateComingG = @$totalArr[$contractor->id]['total']['late_coming_variance'] ?: 0;

                                            if (is_numeric(@$contractor->userDetail->short_excess_max_allowed) && $shortExcessG > @$contractor->userDetail->short_excess_max_allowed) {
                                                $shortExcessBg = 'bg-light-danger';
                                            } else {
                                                $shortExcessBg = 'bg-light-success';
                                            }

                                            if (is_numeric(@$contractor->userDetail->late_coming_max_allowed) && $lateComingG > @$contractor->userDetail->late_coming_max_allowed) {
                                                $lateComingBg = 'bg-light-danger';
                                            } else {
                                                $lateComingBg = 'bg-light-success';
                                            }
                                        @endphp
                                        <td class="text-nowrap {{ $shortExcessBg }}">
                                            <strong>{{ $shortExcessG }}</strong>
                                        </td>
                                        <td class="text-nowrap {{ $lateComingBg }}">
                                            <strong>{{ $lateComingG }}</strong>
                                        </td>
                                    @endforeach
                                </tr>
                                <tr>
                                    <td style="font-weight:bold;color:#000000; background-color:rgb(255, 255, 255);" class="text-nowrap">Total Incidents</td>
                                    @foreach ($contractors as $contractor)
                                        @foreach ($shifts as $key => $shift)
                                            <td class="text-nowrap"
                                                style="text-align: center; font-weight:bold;color:#000000" colspan="2">
                                                {{ @$totalArr[$contractor->id][$shift->id]['total_incidents'] ?: 0 }}</td>
                                        @endforeach
                                        <td class="text-nowrap" style="text-align: center; font-weight:bold;color:#000000"
                                            colspan="2">
                                            {{ @$totalArr[$contractor->id]['total']['total_incidents'] ?: 0 }}</td>
                                    @endforeach
                                </tr>
                            </tfoot>
                        </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