@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 action="{!! route('rota-plan-report',['alias'=>$alias]) !!}" method="POST">
        <input type="hidden" name="_token" value="{{ csrf_token() }}" />
        <input type="hidden" id="table_head" value="{{ count($contractors)+2 }}" />
        <input type="hidden" name="search" value="1">

    <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)?:date('Y-m-d')}}" 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_id" id="department_id">
                        <option value="" selected></option>
                        @foreach($departments as $department)
                                        <option value="{{$department->id}}" @if($department->id == $departmentId )) 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_id" id="designation_id">
                        <option value="" selected></option>
                         @foreach($designations as $designation)
                                        <option value="{{$designation->id}}"  @if($designation->id == $designationId )) 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_id" id="shift_id">
                        <option value="" selected></option>
                       @foreach($shifts as $shift)
                                        <option value="{{$shift->id}}"  @if($shift->id == $shiftId )) 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_id" id="contractor_id">
                        <option value="" selected></option>
                       <option value="on_roll">On Roll</option>
                                    @foreach($contractorList as $contractor)
                                        <option value="{{$contractor->id}}" @if($contractor->id == $contractorId )) 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?date={{($date)?:date('m/d/Y')}}&department_id={{$department_id}}&designation_id={{$designation_id}}&shift_id={{$shift_id}}&contractor_id={{$contractor_id}}" style="display: initial;"><button type="button" class="btn btn-primary waves-effect waves-float waves-light">
                        <span> Excel</span>
                        </button></a>
                </div>
                @if($shiftId==null)
                <div class="table-responsive">
                    <h5 class="text-center" style="font-weight: bold">{{trans('master/master.all_shift')}}</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>
                                                @if($contractorId==null || $contractorId=='on_roll')
                                                <th class="text-center" colspan="3" style="font-weight:bold;color:#000;">{{trans('master/master.on_roll')}}</th>
                                                @endif
                                                @if($contractorId!='on_roll')
                                                    @foreach($contractors as $contractor)
                                                    <th class="text-center" colspan="3" style="font-weight:bold;color:#000;">{{ $contractor->name }}</th>
                                                    @endforeach
                                                @endif
                                                <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>
                                                    @if($contractorId==null || $contractorId=='on_roll')
                                                    <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.absent')}}</td>
                                                    @endif
                                                    @if($contractorId!='on_roll')
                                                        @foreach($contractors as $contractor)
                                                        <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.absent')}}</td>
                                                        @endforeach
                                                    @endif
                                                    <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.absent')}}</td>
                                                    
                                                </tr>
                                                @foreach($dataArray as $key=>$data)
                                                <tr>
                                                    <td class="text-nowrap">{{$data['department']}}</td>
                                                    <td class="text-nowrap">{{$data['designation']}}</td>
                                                    @if($contractorId==null || $contractorId=='on_roll')
                                                    <td class="text-nowrap plan_emp">{{$data['plan']}}</td>
                                                    <td class="text-nowrap present_emp">{{$data['present']}}</td>
                                                    <td class="text-nowrap absent_emp">{{$data['absent']}}</td>
                                                    @endif
                                                    @if($contractorId!='on_roll')
                                                        @foreach($data['contractorEmp'] as $key1=>$value)
                                                        <td class="text-nowrap contractor_plan_emp{{$loop->iteration}}">{{$value['plan']}}</td>
                                                        <td class="text-nowrap contractor_present_emp{{$loop->iteration}}">{{$value['present']}}</td>
                                                        <td class="text-nowrap contractor_absent_emp{{$loop->iteration}}">{{$value['absent']}}</td>
                                                        @endforeach
                                                    @endif
                                                    <td class="text-nowrap total_plan_emp" style="font-weight:bold">{{$data['totalPlan']}}</td>
                                                    <td class="text-nowrap total_present_emp" style="font-weight:bold">{{$data['totalPresent']}}</td>
                                                    <td class="text-nowrap total_absent_emp" style="font-weight:bold">{{$data['totalPlan']-$data['totalPresent']}}</td>
                                                </tr>
                                                @endforeach
                                                <tr>
                                                    <td style="font-weight:bold">{{trans('master/master.total')}}</td>
                                                    <td class="text-nowrap"></td>
                                                    @if($contractorId==null || $contractorId=='on_roll')
                                                    <td class="text-nowrap sum_plan_emp" style="font-weight:bold"></td>
                                                    <td class="text-nowrap sum_present_emp" style="font-weight:bold"></td>
                                                    <td class="text-nowrap sum_absent_emp" style="font-weight:bold"></td>
                                                    @endif
                                                    @if($contractorId!='on_roll')
                                                        @foreach($contractors as $contractor)
                                                        <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
                                                    @endif
                                                    <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>
                                            </tbody>
                    </table>
                </div>
                @endif

                @foreach($shiftDataArray as $key=>$shiftData)
                <div class="table-responsive">
                    <h5 class="text-center" style="font-weight: bold;margin-top: 18px;">{{$key}}</h5>
                    <table class="table mb-0 emp_table" id="request1">
                        <thead>
                                                <th></th>
                                                <th></th>
                                                @if($contractorId==null || $contractorId=='on_roll')
                                                <th class="text-center" colspan="3" style="font-weight:bold;color:#000">{{trans('master/master.on_roll')}}</th>
                                                @endif
                                                @if($contractorId!='on_roll')
                                                    @foreach($contractors as $contractor)
                                                    <th class="text-center" colspan="3" style="font-weight:bold;color:#000">{{ $contractor->name }}</th>
                                                    @endforeach
                                                @endif
                                                <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>
                                                    @if($contractorId==null || $contractorId=='on_roll')
                                                    <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.absent')}}</td>
                                                    @endif
                                                    @if($contractorId!='on_roll')
                                                        @foreach($contractors as $contractor)
                                                        <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.absent')}}</td>
                                                        @endforeach
                                                    @endif
                                                    <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.absent')}}</td>
                                                    
                                                </tr>
                                                @foreach($shiftData as $shiftData)
                                                <tr>
                                                    <td>{{$shiftData['department']}}</td>
                                                    <td>{{$shiftData['designation']}}</td>
                                                    @if($contractorId==null || $contractorId=='on_roll')
                                                    <td class="plan_emp">{{$shiftData['plan']}}</td>
                                                    <td class="present_emp">{{$shiftData['present']}}</td>
                                                    <td class="absent_emp">{{$shiftData['absent']}}</td>
                                                    @endif
                                                    @if($contractorId!='on_roll')
                                                        @foreach($shiftData['contractorEmp'] as $conEmp)
                                                        <td class="contractor_plan_emp{{$loop->iteration}}">{{$conEmp['plan']}}</td>
                                                        <td class="contractor_present_emp{{$loop->iteration}}">{{$conEmp['present']}}</td>
                                                        <td class="contractor_absent_emp{{$loop->iteration}}">{{$conEmp['absent']}}</td>
                                                        @endforeach
                                                    @endif
                                                    <td class="total_plan_emp" style="font-weight:bold">{{$shiftData['totalPlan']}}</td>
                                                    <td class="total_present_emp" style="font-weight:bold">{{$shiftData['totalPresent']}}</td>
                                                    <td class="total_absent_emp" style="font-weight:bold">{{$shiftData['totalPlan']-$shiftData['totalPresent']}}</td>
                                                </tr>
                                                @endforeach
                                                <tr>
                                                    <td style="font-weight:bold">{{trans('master/master.total')}}</td>
                                                    <td></td>
                                                    @if($contractorId==null || $contractorId=='on_roll')
                                                    <td class="sum_plan_emp" style="font-weight:bold"></td>
                                                    <td class="sum_present_emp" style="font-weight:bold"></td>
                                                    <td class="sum_absent_emp" style="font-weight:bold"></td>
                                                    @endif
                                                    @if($contractorId!='on_roll')
                                                        @foreach($contractors as $contractor)
                                                        <td class="sum_contractor_plan_emp{{$loop->iteration}}" style="font-weight:bold"></td>
                                                        <td class="sum_contractor_present_emp{{$loop->iteration}}" style="font-weight:bold"></td>
                                                        <td class="sum_contractor_absent_emp{{$loop->iteration}}" style="font-weight:bold"></td>
                                                        @endforeach
                                                    @endif
                                                    <td class="total_sum_plan_emp" style="font-weight:bold"></td>
                                                    <td class="total_sum_present_emp" style="font-weight:bold"></td>
                                                    <td class="total_sum_absent_emp" style="font-weight:bold"></td>
                                                </tr>
                                            </tbody>
                    </table>
                </div>
                @endforeach
            </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>
     $(document).ready(function() {
        var head = $('#table_head').val();
        for(i=1; i<=head; i++){

        }
        $('.emp_table').each(function() {
        for(i=1; i<=head; i++){
            var sum1 = 0;
            var sum2 = 0;
            var sum3 = 0;
            if(i==1){

                $(this).find('.plan_emp').each(function() {
                    var plan_emp = $(this).text();
                    if (!isNaN(plan_emp) && plan_emp.length !== 0) {
                      sum1 += parseFloat(plan_emp);
                    }
                });
                $(this).find('.sum_plan_emp').html(sum1);

                $(this).find('.present_emp').each(function() {
                    var present_emp = $(this).text();
                    if (!isNaN(present_emp) && present_emp.length !== 0) {
                      sum2 += parseFloat(present_emp);
                    }
                });
                $(this).find('.sum_present_emp').html(sum2);

                $(this).find('.absent_emp').each(function() {
                    var absent_emp = $(this).text();
                    if (!isNaN(absent_emp) && absent_emp.length !== 0) {
                      sum3 += parseFloat(absent_emp);
                    }
                });
                $(this).find('.sum_absent_emp').html(sum3);

            }else if(i==head){
                $(this).find('.total_plan_emp').each(function() {
                    var total_plan_emp = $(this).text();
                    if (!isNaN(total_plan_emp) && total_plan_emp.length !== 0) {
                      sum1 += parseFloat(total_plan_emp);
                    }
                });

                $(this).find('.total_sum_plan_emp').html(sum1);

                $(this).find('.total_present_emp').each(function() {
                    var total_present_emp = $(this).text();
                    if (!isNaN(total_present_emp) && total_present_emp.length !== 0) {
                      sum2 += parseFloat(total_present_emp);
                    }
                });

                $(this).find('.total_sum_present_emp').html(sum2);

                $(this).find('.total_absent_emp').each(function() {
                    var total_absent_emp = $(this).text();
                    if (!isNaN(total_absent_emp) && total_absent_emp.length !== 0) {
                      sum3 += parseFloat(total_absent_emp);
                    }
                });

                $(this).find('.total_sum_absent_emp').html(sum3);
            }else{
                var cls = i-1;
                $(this).find('.contractor_plan_emp'+cls).each(function() {
                    var contractor_plan_emp = $(this).text();
                    if (!isNaN(contractor_plan_emp) && contractor_plan_emp.length !== 0) {
                      sum1 += parseFloat(contractor_plan_emp);
                    }
                });

                $(this).find('.sum_contractor_plan_emp'+cls).html(sum1);

                $(this).find('.contractor_present_emp'+cls).each(function() {
                    var contractor_present_emp = $(this).text();
                    if (!isNaN(contractor_present_emp) && contractor_present_emp.length !== 0) {
                      sum2 += parseFloat(contractor_present_emp);
                    }
                });

                $(this).find('.sum_contractor_present_emp'+cls).html(sum2);

                $(this).find('.contractor_absent_emp'+cls).each(function() {
                    var contractor_absent_emp = $(this).text();
                    if (!isNaN(contractor_absent_emp) && contractor_absent_emp.length !== 0) {
                      sum3 += parseFloat(contractor_absent_emp);
                    }
                });

                $(this).find('.sum_contractor_absent_emp'+cls).html(sum3);
            }
        }

      })


        $('#date').datepicker({
            todayHighlight:'TRUE',
            autoclose: true,
            changeMonth: true,
            changeYear: true,
            minDate: 0
        });

        $('#request1').DataTable({
            "scrollX": "100%",
            "scrollCollapse": true,
            "ordering": false,
            "order": [[ 0, "desc" ]]
        });
    });

</script>





@endpush